URGENT !! Pls HELP, Slow and Strange
I use a VB6 program to generate records and write to a temp table and
after the user amend the record which then transfer to the master table.
I have a Advance server with 312MB Ram PIII500 which install the SQL
database and the performance is fine, for 450 recs it took 20 seconds.
BUT I use the same code program and same database which installed on a
PII 400 NT4 512MB ram and it took me 5 minutes to complete the 8 recs!!!
I tried to use the
direct sql statement
insert ... values...
but the two method still get the same slow result 8recs cost 5 minutes!!
Do anyone can help me.
Thanks in advance