Re: Database having 10K transactions on daily basis
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.
Subject
Views
Written By
Posted
2978
December 24, 2004 01:14AM
2105
December 29, 2004 09:09PM
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.