Re: splitting a big table
Fabien Roy <[email protected]>
| Newsgroups | gmane.comp.web.webobjects.devel,gmane.comp.web.webobjects.eof |
|---|---|
| Message-ID | <[email protected]> |
Which database are you using? How many inserts per day? You can still have decent query time by using indices. Did you profile the query plan for that table? Fabien On Thursday, Jan 9, 2003, at 10:20 America/Los_Angeles, Christian Pekeler wrote: > I am running into a problem. The table has over 40 million records and > it is getting slow. > > > Christian