186 reputation
2
bio website
location
age
visits member for 1 year, 3 months
seen Mar 23 at 23:48

Dec
14
comment Move data from one table to another
put delete after insert
Dec
14
comment How can one improve the performance of a query that selects on a low cardinality column in MySQL?
If you want all rows satisfying the equality condition, index is useless
Dec
14
comment Insert Speeds for large batches
Could you make your batch size large, say 1000?
Sep
24
answered Optimizing mysql queries running on 50 million rows
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?