Hello,

now I see more or less where is my problem... I will try to reduce my query
(or separate it into smaller queries). However, could someone tell me how
much space may take a temporary file of 18000 rows and 7 or 8 columns? More
than 200 Mb, for example?

Thank you for everything,

Xavier.

A Divendres 08 Març 2002 09:48, vàreu escriure:

> > 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."
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

--
Xavier Solé Acha (mailto:x.sole@...)
Servei d'Epìdemiologia i Registre del Càncer
Institut Català d'Oncologia
Av. Gran Via km. 2,7
08907 L'Hospitalet de Llobregat, Barcelona
Tel: +34 932 607 401
Tel: +34 932 607 787