RE: Adding indexes on large tables

2003-10-07 Thread Brad Teale
Brendan, We have used ext2, ext3, and reiser for testing purposes, and we have found ext3 to be terribly slow on file read/write operations. If you need a journaling file system, I would go with reiser, otherwise ext2 will be blazingly fast. The other thing I would do is move your DB to anoth

RE: Adding indexes on large tables

2003-10-07 Thread Dan Greene
an option for A- no idea if this will work, but what if you moved your actual data file to new drive, and soft linked it from the other drive? > -Original Message- > From: Brendan J Sherar [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 07, 2003 7:27 AM > To: [EMAIL PROTECTED] > Subje