Richard Hipp : Thanks for explain me that... so what do you think will be the solution? what do you think about db in Clustering.
On 7/13/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
"Cesar David Rodas Maldonado" <[EMAIL PROTECTED]> wrote: > About the concurrence, i don't know... about 2000 queries per second... Wich > db engine will be good?... i have a server with 2 GB ram, AMD sempron > 64bits, > You have 8 billion records and 2 billion bytes of ram. So your data will not fit in cache. That means it will have to be read from disk. Let's assume each query does a single disk access. Suppose you have a very high-performance disk drive with a 5ms access time. That gives you 200 queries per second - 1/10th of what you want. 200 queries per second is your speed-of-light. No software will allow you to go faster. You'll have to get better hardware. -- D. Richard Hipp <[EMAIL PROTECTED]>
