Daniel Åkerud wrote:
> In MySQL having a table that looks like this:
>
> id int primary key
> name char(200)
>
> and making an index on name, will get you a 0.1 * original_retrieval_time
> when searching, but 1.5*original_insertion_time when inserting. It roughly
> means that (on my system that is) you should do at least one select
> statement for every 4000 inset statements, for the index to be profitable.
> So, keep in mind that an index wont allways suit you, but mostly.
Where did you get this numbers from, are they some general factors or do
they depend
on the table design?
//Eric
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
