How to measure the speed

• Quoting Mark Ling to All dated 09-25-94 ***
  > I have a very simple question: My client asked me that How long I
  > need to search one recorder from a 500*half million data table in Oracle
  > data base, the Oracle was installed in 486DX66 server which is hooked up
  > by ether net.
  

This is very platform and implementation specific; however, even on a table this size, a well-tuned database searching on a highly differentiated index should be able to return a row in under a second.

> My client's bottom line is 3 second, is it possible? how can I know
> whether it's possible or not? If it is impossible, updating the computer
> server, say using Pentinm 100 , can reach that goal(3 second for searching
> one recorder)?

The only sure way is to build a valid test case. Any extrapolation would be platform-specific, and small-sample extrapolations aren't valid, i.e., if it takes half a second to retrieve a record from a 10 row table, it does NOT mean that it takes 13 hours to retrieve a record from a 100000 row table -- generally, it would also take half a second. I would say it is possible, but you haven't said what platform you're running on. Received on Mon Sep 26 1994 - 16:18:58 CET