I don't care about hardware... i will do cluster... but which DB motor do
think will be good for work with great velocity in select (sqlite,
postgresql or mysql).
ah.. i almost forgot... i will do a great number of select...

On 7/12/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote:

32 bits, the size of the key, only holds numbers up to 2 or 4 billion.
You said you have 8 billion rows.
You need a 64 bit version or to split up the data into many tables.


On 7/12/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
> So Jay... Do you think that i have to use a PC of 64 bits, or 32bits pc
with
> clustering?
>
>
> On 7/12/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
> >
> > > Hello to everybody!
> > >
> > > I want to ask to the people something... If i have a table with
about
> > > 8.000.000.000 registers, and i have to do a select in a numeric row
that
> > > will have index. what db do you recommend to me for use?
> >
> > If you design the database correctly it should work, but I believe
> > that large a total number of records will not be addressable on
> > a personal computer. I think the 32 bit version is limited to 2^32
> > records.
> >
>
>


--
--
SqliteImporter and SqliteReplicator: Command line utilities for Sqlite
http://www.reddawn.net/~jsprenkl/Sqlite

Cthulhu Bucks!
http://www.cthulhubucks.com

Reply via email to