When is INDEX rehashed?
This is a discussion on When is INDEX rehashed? within the MySQL forums, part of the Database Server Software category; --> I'm a newbie in MySQL & DBMS. I made a LEXICON table which has msyl(varchar), asyl(varchar), and insert 200,000 ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 10:17 AM
| ||||
| ||||
 When is INDEX rehashed? I'm a newbie in MySQL & DBMS. I made a LEXICON table which has msyl(varchar), asyl(varchar), and insert 200,000 entries into it. Due to long retrieving time, I decided to create INDEX on LEXICON(msyl, asyl). But, My System got to be pretty slow. Can createing INDEX just cause low performance like this? Best Regards.      |
|
02-28-2008, 10:17 AM
| |||
| |||
| Re: When is INDEX rehashed? iaminsik wrote: > I'm a newbie in MySQL & DBMS. > > I made a LEXICON table which has msyl(varchar), asyl(varchar), and > insert 200,000 entries into it. > Due to long retrieving time, I decided to create INDEX on > LEXICON(msyl, asyl). > > But, My System got to be pretty slow. > Can createing INDEX just cause low performance like this? > > Best Regards. > no but a bad query can! |
|
02-28-2008, 10:22 AM
| ||||
| ||||
| Re: When is INDEX rehashed? On 7 25 , 10 26 , lark <ham...@sbcglobal.net> wrote: > iaminsik wrote: > > I'm a newbie in MySQL & DBMS. > > > I made a LEXICON table which has msyl(varchar), asyl(varchar), and > > insert 200,000 entries into it. > > Due to long retrieving time, I decided to create INDEX on > > LEXICON(msyl, asyl). > > > But, My System got to be pretty slow. > > Can createing INDEX just cause low performance like this? > > > Best Regards. > > no but a bad query can! Thanks, I'll solve it.  |
 |
« Moving row to different table, and changing value at same time
|
using mysql-connector-net in .NET »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 03:05 PM.
