MySQL Forums
Forum List  »  Optimizer & Parser

Re: slow selects
Posted by: Danie Van der Walt
Date: September 01, 2006 07:24AM

Thanks the reason I used innodb was for row level locking....
which from what I understand was much faster...

Whould you suggest myisam.... with the index change....

it has about 5000 records but like today we can have over 150K records in...



Edited 1 time(s). Last edit at 09/01/2006 08:06AM by Danie Van der Walt.

Options: ReplyQuote


Subject
Views
Written By
Posted
2723
August 31, 2006 08:02AM
1860
August 31, 2006 08:43AM
1865
August 31, 2006 09:06AM
1876
September 01, 2006 03:04AM
1826
September 01, 2006 04:17AM
2094
September 01, 2006 04:50AM
Re: slow selects
1836
September 01, 2006 07:24AM
1876
September 01, 2006 08:16AM
1871
September 02, 2006 12:52PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.