[thelist] ODBC Text File Driver and ASP

[Simon Davies]

Hi Anthony

I'm doing something similar but only with 60,000 rows...no need to use such
extreme measures. I do offer the function to DBCC REINDEX, Truncate Server
Log and/or Update Statistics if the server becomes irritable though (use VB6
as a front end for "dumb" users to upload AS400 data to SQL Server 2000 db).

Take a look at http://www.sql-server-performance.com/ for SQL Server tuning
tips, its a good read.

Simon

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Anthony Baratta
Sent: Tuesday, 28 November 2000 09:44
To: thelist at lists.evolt.org
Subject: Re: [thelist] ODBC Text File Driver and ASP


Simon Davies wrote:
>
> Hi
>
> Why do you need to drop the table? If you need to clear its rows why not
use
> Truncate instead. You would still have to drop the indexes if they are
> slowing the upload though.

Simon....

We are updating product delivery data daily (6 tables with a total of 800K
rows) for
our client that is being used by a Web based application. Because the data
is only
updated in bulk: we drop the tables, re-create the tables, load the data,
then
rebuild the indexes. According to my research this reduces "fragmentation"
of the
tables and garbaging up the indexes by building them after all the data is
loaded
versus being updated during the bulk load.

Besides according to the documentation I've unearthed on BulkCopy and BULK
INSERT,
having indexes on the target table(s) are either not supported or will slow
the load
considerably. Speed is VERY important in this process and building the
indexes after
the data is loaded makes the overall process faster.

--
Anthony Baratta
President
KeyBoard Jockeys
                    South Park Speaks Version 3 is here!!!
                       http://www.baratta.com/southpark
                              Powered by Tsunami

---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !