MySQL Forums
Forum List  »  Performance

Re: Database having 10K transactions on daily basis
Posted by: Peter Zaitsev
Date: December 31, 2004 02:01AM

10K/day is not much even for search application.

You should try to avoid full table scans at first is by using BOOLEAN Full Text search.

Also caching is what is really important for search applications - sometimes query cache can help a lot in some cases caching search result set in special tables works better.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Database having 10K transactions on daily basis
1954
December 31, 2004 02:01AM


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.