Tag Info

New answers tagged

0

A different approach to the question/answer: What is cached when you run the query? If what you "need" is cached in RAM, there is essentially no difference is speed. You "need" m "rows" from the index; these will be blocked and consecutive (as @jynus discusses). m rows of data. Because the rows were inserted essentially in t order, they will also be ...


1

Broadly speaking, on a MyISAM Table with a range scan, the process is: Find the first Index result using the BTREE (inside the .MYI file) and access the row result (on the .MYD file) - Handler_read_key Get the next result, using the index (and in the same order), until the value retrieved is larger than the one defined (multiple instances of ...


0

If filter 110M is exactly a subset of filter 126M, then appending more AND with WHERE would have done the job. $sql1 = "SELECT ..... WHERE ..."; $sql2 = $sql1 . "AND column-name = ...."; $sql3 = $sql2 . "AND column-name = ...."; If that is complex to accomplish try to CREATE VIEW of the previous SELECT statement and the next SELECT statement should ...



Top 50 recent answers are included