Hi all,
I've got a database that has a few thousand rows, I've noticed that some
of the search queries (especially the large ones) are taking some time.
Im looking at adding indexes to my tables in order to speed up the data
retrieval.
My question is as follows: At this point in time if I
Angelo, results should be (nearly) immediate. When you add an index,
MySQL creates an index for the existing data in your table. Later,
when data is added/updated/deleted, the index is updated
simultaneously.
With a few thousand rows, you should be able to get by adding a few
indexes where
In the last episode (Oct 03), Angelo Zanetti said:
I've got a database that has a few thousand rows, I've noticed that
some of the search queries (especially the large ones) are taking
some time. Im looking at adding indexes to my tables in order to
speed up the data retrieval.
My question
Dan Nelson wrote:
In the last episode (Oct 03), Angelo Zanetti said:
I've got a database that has a few thousand rows, I've noticed that
some of the search queries (especially the large ones) are taking
some time. Im looking at adding indexes to my tables in order to
speed up the data
At 05:42 PM 10/3/2006, you wrote:
Dan Nelson wrote:
In the last episode (Oct 03), Angelo Zanetti said:
I've got a database that has a few thousand rows, I've noticed that
some of the search queries (especially the large ones) are taking
some time. Im looking at adding indexes to my tables