network profile
| bio | website | brunoreis.com/tech |
|---|---|---|
| location | Sao Paulo, Brazil | |
| age | 26 | |
| visits | member for | 1 year, 2 months |
| seen | Jul 7 '12 at 3:50 | |
| stats | profile views | 5 |
Mechatronics Engineer from Poli/USP (University of São Paulo, Brazil) and General Engineer from École Centrale de Lille (Lille, France).
Passionate about software programmer since a kid. Interested in algorithms, concurrency, scalability, big data, object oriented and functional programming.
|
Apr 10 |
awarded | Scholar |
|
Apr 10 |
accepted | How to make MySQL 5.1 connection ignore kills? |
|
Apr 10 |
revised |
How expensive are SELECT FROM LIKE statements from a design perspective? added 509 characters in body |
|
Apr 10 |
revised |
How expensive are SELECT FROM LIKE statements from a design perspective? added 179 characters in body |
|
Apr 10 |
revised |
How expensive are SELECT FROM LIKE statements from a design perspective? added 1 characters in body |
|
Apr 10 |
answered | How expensive are SELECT FROM LIKE statements from a design perspective? |
|
Apr 10 |
comment |
How expensive are SELECT FROM LIKE statements from a design perspective? let us continue this discussion in chat |
|
Apr 10 |
comment |
How expensive are SELECT FROM LIKE statements from a design perspective? Also: what exactly is your "criteria"? Is it really free text? Could you make it somehow a bit more structured? FYI, the first of your queries ( like 'xxx%') would run fast if the column is the last part of the used key, while the others (like '%xxx' or like '%xxx%') would run slow (in the worst situation -- without more conditions, as in your examples -- you would have a full table scan, which would likely kill your server). |
|
Apr 10 |
comment |
How expensive are SELECT FROM LIKE statements from a design perspective? What kind of content are you talking about? How are you using this content? What exactly do you mean by small (in bytes)? Is your content mostly read-only, or is it frequently updated? |
|
Apr 10 |
comment |
How expensive are SELECT FROM LIKE statements from a design perspective? Would you care to explain a bit more about your original situation? What exactly is your problem? Why must you reduce the number of files? I ask because I might have a similar situation, but mine is totally under control. I have a single, small server serving about 15M requests per day randomly distributed among about 2.5M small static files (mainly images, most around 0.6kb - 2.5kb, some a little bigger), and I can assure you that the server load is very, very low: it could handle a lot more. |
|
Apr 8 |
awarded | Teacher |
|
Apr 8 |
awarded | Student |
|
Apr 7 |
awarded | Editor |
|
Apr 7 |
revised |
How to make MySQL 5.1 connection ignore kills? added 191 characters in body |
|
Apr 7 |
answered | How to make MySQL 5.1 connection ignore kills? |
|
Apr 7 |
asked | How to make MySQL 5.1 connection ignore kills? |
|
Apr 7 |
awarded | Autobiographer |
