Actually I deduced the file size is not really the problem. After reaching 6 mill records, I ran a simple query asking for the last 50 records from my app. Using strace I figured that the DB is actually running thru *all the records* to return me the last 50 and while doing that it locked the DB! Maybe I constructed my query wrong???? It looks something like this:
select fields from table order by id desc limit 50; Any ideas??? On 7/20/05, R S <[EMAIL PROTECTED]> wrote: > Actually it is an ext3...and I guess the File Size limitation on ext3 is 4TB. > > > On 7/20/05, F.W.A. van Leeuwen <[EMAIL PROTECTED]> wrote: > > t the same as PARTIT >
