They most certainly do depend on the table design and especially on the
system which runs the test.
They are my own figures...
> 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
