> >While I'm on the topic, are there any
> >limits to the number of other db items, eg generators etc?
>
> Sure. Ask. A generator is a signed BigInt and will "run out" after the
> 18,446,744,073,709,551,615th number has been generated. Of more interest
> is that you can't have close to that number of records or unique serial
> numbers in a single table. It's currently limited to around 2.1 billion,
> including uncollected garbage and uncommitted work. It will be less if

the

> row size spreads across more than one database page and/or contains blobs
> that could fill multiple pages. So you do need to think about history
> tables for big tables...

And one other thingy, the maximum number of generators... I cannot
recall what it was, but Helen sure does ... Care to refresh my memory
on this one?

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com