Ah, that'll help. Looks like mysql-5 will have what we need:
http://dev.mysql.com/doc/refman/5.1/en/partitioning.html I see it's on the TODO list for postgresql http://www.postgresql.org/docs/faqs.TODO.html Eugene Prokopiev wrote: >>> If anybody now how to do optimize MySQL tables in such hard terms >>> - please answer. >> >> >> >> I'm open to suggestions and ideas here. I've been having this very same >> problem. > > > http://dev.mysql.com/doc/refman/4.1/en/merge-storage-engine.html > > Big RDBMS (Sybase, Oracle) have advanced table partitioning features, > which help me to store more than 100Gb in one Oracle table. > -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl