Jay gave you the clue. You need to have software and hardware which
will address data beyond 32 bits, i.e. 64 bit file addressing. The 64
bit file version of all the tools you mention should perform your job.
Now you choose according to the scale of your application, Enterprise,
Department or Embedded. Postgresql would work in the Enterprise and
Sqlite for an embedded application.
For a heavy duty application 64 bits hardware and OS would be the best.
Cesar David Rodas Maldonado wrote:
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
