> 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 (just) don't return 100000 rows. Unless running some report and then
they
allocate lots of temp space...

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."