Re: SQL Query problem take ages to run
From: Max (maxl_at_msn.com)
Date: 12/12/04
- Next message: Max: "Re: open_tran = 1"
- Previous message: Max: "Re: Passing large amounts of text to append to an NText field on the s"
- In reply to: -Permood: "Re: SQL Query problem take ages to run"
- Messages sorted by: [ date ] [ thread ]
Date: 11 Dec 2004 16:02:03 -0800
You cannot turn off logging for an INSERT.
You can use Windows' Performance Monitor to track Disk I/O. I'm
certain you'll have Disk I/O slowness on your first execution of this.
Thus, if possible, you should rebuild your database, pre-allocating all
the space.
For optimal performance, put Tempdb, the transaction log and the
database devices on separate spindles. You want to maximize your disk
i/o by not having to seek your disk frequently.
- Next message: Max: "Re: open_tran = 1"
- Previous message: Max: "Re: Passing large amounts of text to append to an NText field on the s"
- In reply to: -Permood: "Re: SQL Query problem take ages to run"
- Messages sorted by: [ date ] [ thread ]
