Jump to content

Archived

This topic is now archived and is closed to further replies.

hvle

Mysql performance concern

Recommended Posts

I have a table name prob.

prob has 2 fields:

- ID: Interger, AutoIncrement

- Code: varchar 20

 

both fields are indexed and table is myISAM.

 

I currently have about 3 millions records in the table. In other word, I have 3 millions codes, these codes are distinct.

 

when I query: select * from prob where code='84l4jf983jf938'; (this code is not existed in database)

 

After about 6 seconds, an empty result is returned.

 

This post is not about error, I have no error. I only concern about the performance: 6 seconds is disasterous!!!

 

I suppose the indexes are store in binary tree, 3 millions records will average up to about depth 13. If it is 13 depth, how can it take 6 seconds to compare 13 20-chars string?

 

Any mysql expert might explain why it should take ridiculously long, and how can I optimize it?

 

 

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.