At 03:25 PM 08-03-02 -0500, you wrote:

>Well... the database is still under development, so I have only inserted data
>to test it. Currently, the table "Spot" has over 9000 rows, and the table
>"RawData" has over 18000. My Stored Procedure returns 18000 rows
>approximately. In the future, the table "RawData" may contain up to a few
>million (3 or 4). What will happen if I want to make a query with an ORDER BY
>which returns 100000 rows or more? Will I allways have the same problem? What
>do people do when they have tera-databases?

They store, process and retrieve data. Perhaps you could get more specific
responses to your questions if you explain a few things about the user
requirements. I'm curious to know what a user is going to do with an
output set of 100,000 rows of raw data.

Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________