On Tue, 2008-04-22 at 09:40 +0530, Anshum wrote: > Any other suggestions for handling a concurrency of over 7 search requests > per second for an index size of over 15Gigs containing over 13 million > records?
Our index is 30GB+ with 9 million records and a machine handles an average search in about 250 ms. This is without proper warm-up and using conventional harddisks, simple queries and simple processing of hits (extraction of a field from the first 20 hits). How often do you change your index and do you perform any kind of warm-up? What is a typical query, how many hits does it return and what do you do with the hits? > Also, could someone help me with obtaining a 'index size' - 'concurrency' - > 'processor power' - 'memory' relationship formula (or something similar)? I doubt that you'll find a formula as such, as there are so many variables influencing performance. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]