>
> > At 02:56 AM 23/04/2006, you wrote:
> > >We have huge database ( 30 GB) that seems to be working ok on
> > >Windows. We need to port this database to Linux. Transportable
> > >backup file is about 20GB in size. Biggest table is about 185
> > >millions of records.

At 11:56 AM 23/04/2006, you wrote:

>Our Linux is CentOS 4.3 (RedHat Enterprise clone) with ext3
>partition. We have configured /tmp to be used for temp files and
>this directory spans across entire disk space. We have about 90 GB
>available for it to grow.. FB has `rwx' permissions there…
>
>We have also tried to increase SortMemBlockSize and
>SortMemUpperLimit with no success. Any other suggestions?

Not a lot. What data type is the primary key defined as in your metadata?

PLEASE DO NOT TOP POST WHEN YOU REPLY TO POSTINGS !!
Edit the existing text and place your reply within the text and/or at the end.

./heLen