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?

Please help!!

Xavier.

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

> I was about to suggest the same , but also , it can be a problem of write
> permision , or quotas.
> Also that issues a perfomance boost I have been triying , using reiserfs
> for the database files but a simple ext2fs for tmp partition.
> (yesterday , after a gone wild report generation , had to remove 800Mb of
> two /tmp/gds_sort* files)
> the perfomace boost seems to be related to the overhead that the extra
> cheks of ReiserFs puts on the system.
>
> exactly , Xavi , What size of tables are we talking of ?
>
> Javi
> EntreBytes S.L.
> Ontenient , Spain
> ERP Development.
> ----- Original Message -----
> [Snip]
>
> > Xavier,
> > Is it possible you are out of space in /tmp? You can actually configure
> > specific areas your filesystem for the temp sort files...I don't use /tmp
> > for sort files at all because my setup has only a 2 Mb /tmp partition.
> >
> > regards,
> > Helen
>
>
> 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