Performance problem

Performance problem

Post by Peter » Tue, 04 May 1999 04:00:00

We have a customer whos database I recently upgraded from
SQL 6.5 to 7.0 WITH UPGRADE WIZZARD. The database was EMPTY
when doing so. I haven't done anything more with the database,
like finetuning indexes.

One essential part of the application wich uses the database is
reading BIG textfiles into tables. In a week now we have read
in about 150 4 MEG textfiles into the database. (This isn't common,
there will only be one file a week in the future)

HOWEVER: I turns out that SQL 7.0 needs 3 - 4 times more time to read
texfiles and update tables.

I checked the statstics info with STAT_DATE (or something like that)
and it looks like the statistics are updated since the dates
are recent. Therefore I haven't ran the UPDATE STATISTICS yet.

Unfortunately there are no stored procedures for handling the update,
every row is handled in VB and every row is added and updated from
VB with RDO. I think the database is opened and closed frequently
under the reading / updating sessions. But why do I have the

What could be wrong?


1. SQL Server Performance Problem - Good query performance, bad update performance

We've run into a situation with a client who has just moved to the SQL
Server version of our application in which query performance is acceptable,
but updates are at least an order of magnitude too slow. Any thoughts on
what I might check for update-related performance problems? Their machine is
a dual-CPU 600MHZ monster, and my old 200MHZ single CPU Pentium Pro NT
machine is running circles around theirs. I can do 10 transactions in 10
seconds here, while theirs takes over 2 minutes to do a similar transaction

Any thoughts?



2. Compounded Daily Interest

3. Join Performance Problem -- Frustrating!...

4. Informix sessions at IBM developerWorks Live! April 9-12

5. performance problem - procedure called with insert into

6. B/W bitmaps

7. Client Performance Problem

8. Digital Libraries Forum, May 1995, (prelim. program and registration)

9. w2k and ms sql2000 performance problems

10. Performance problems with SQL2000

11. Performance problems with 6.0

12. Performance problems