[* Profanities suppressed to not offend religious beliefs *] !!!!

Hey man , i was suspecting something like that , by the name of the tables
and your signature , but this is getting serius.. maybe interbase is not for
you.. in fact , are you sure you NEED a Relational Database ?

Just as a stab in the dark ... would you consider how to encode the data?
that is.. DNA is just 4 bases, (two bits), arranged
in sequences that gives us nucleotids , peptids and all that amazing stuff
of life .. but ..
what resources are you using to enconde a 2-bit information?

just a througth...

HTH.

- "What is true?" , asked a philospher.
- "1 or 0 , depending on implementations " replied a bystanding programmer.


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 10:56 PM
Subject: Re: [ib-support] Call Interbase Stored Procedure from PHP


> Well, this database will have data coming from DNA microarray experiments.
I
> don't know if you have heard something about them. I just will tell you
that
> one single experiment generates 10000 rows of raw data. Imagine I want to
get
> the raw data of (just) 10 experiments to make some kind of statistical
> analysis with them, this generates the 100000 rows I explained befored.
The
> field of Computational Biology is one of the most challenging ones, and
even
> more if we talk about bilogical databases, which must be able to store
> enormous amount of data.... and now I begin to face this challenge!!
>
> Regards,
>
> Xavier.
>
> A Divendres 08 Març 2002 10:00, vàreu escriure:
> > 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/
> > _______________________________________________________
> >
> >
> >
> > 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/
>
>