Re: Indexing problems

[James Woodward]

Embarassingly enough this was a single query. The WebApp was written by somebody else quite awhile ago. When I realized what you said as far as how much data was being transfered I re-wrote large portions of this page. I'm not confident that this will solve the indexing problem but it's something that should have been fixed.

So I've done a ' show stats LIKE 'Keys%'; and here are the results
i did this test with the code before the change and the code after the change and
the results were identical. Obviosly there was a large difference in the Bytes_sent
but all I've listed are the Key values. The only difference between now and last night
was that I stopped the database to do a few myisamchk checks with -a and -e.
I did a myisamchk -r just in case.

------------------------------------
After Flush
Key_blocks_used: 313
Key_read_requests: 0
Key_reads: 0
Key_write_requests: 0
Key_writes: 0
------------------------------------
After Query 1
Key_blocks_used: 313
Key_read_requests: 118
Key_reads: 0
Key_write_requests: 0
Key_writes: 0
------------------------------------
After Query 10
Key_blocks_used: 313
Key_read_requests: 1180
Key_reads: 0
Key_write_requests: 0
Key_writes: 0
------------------------------------