They use SCSI RAIDS.....

Javi
EntreBytes S.L.
Ontenient , Spain
ERP Development.

----- Original Message -----
From: "Xavier Solé" <x.sole@...>
To: <ib-support@yahoogroups.com>
Sent: Friday, March 08, 2002 9:25 PM
Subject: Re: [ib-support] Call Interbase Stored Procedure from PHP


> 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
>
>
> 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/
>
>