On Apr 1, 2005 4:03 AM, Yudie Pg <[EMAIL PROTECTED]> wrote: > > You need to look at what else is using RAM on that machine. And maybe buy > > more. > > Ouch.. I had that feeling also. then how can I know how much memory > needed for certain amount words? and why counting uncommon words are > faster than common one?
Because the index is a tree. You fall of the end of a branch faster with uncommon words. Plus the executor goes back to the table for fewer real rows with uncommon words. It sounds like you may just need a faster disk subsystem. That would shrink the time for the first query on any particular set of words, and it would make everything else faster as a nice side effect. What does your disk layout look like now? -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
