network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 4 months |
| seen | yesterday | |
| stats | profile views | 9 |
|
Jan 24 |
answered | Query: All employee with sum of salary > 500 |
|
Jan 13 |
comment |
Very Slow MySQL Queries, even with indexes You probability need a horizontal partitioning, especially on the "logs" table. Partitioning on timestamp allows the latest records be put together. But this depends on the version and storage of your MySQL. Here are some references: dev.mysql.com/tech-resources/articles/partitioning.html, dev.mysql.com/doc/refman/5.5/en/partitioning.html |
|
Dec 31 |
awarded | Editor |
|
Dec 31 |
revised |
How to number SQL results sequentially? added 1 characters in body |
|
Dec 30 |
comment |
How to efficiently hit an index in a query that uses IN (mysql) A similar question with answers: stackoverflow.com/questions/586381/… |
|
Dec 27 |
awarded | Teacher |
|
Dec 27 |
answered | How to number SQL results sequentially? |
