[AccessD] Update Query - Need to Speed It Up

Erwin Craps Erwin.Craps at ithelps.be
Tue Jun 3 00:54:45 CDT 2003


That sounds like a good improvement....
Have some experiance with large record tables too, using jet.
 
I don't believe MSDE will be a solution when MSDE is installed on local
machine...
But maybe you should give it a try..
Don't forget you will need changing your code...
 
Nothing beats Jet in speed when using 1 user on 1 computer...
 
 
 
 
-----Oorspronkelijk bericht-----
Van: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] 
Verzonden: maandag 2 juni 2003 23:59
Aan: accessd at databaseadvisors.com
Onderwerp: Re: [AccessD] Update Query - Need to Speed It Up


8:10.  But with Erwin's filter 1:28.  Next stop, I guess is MSDE.
 
Rocky
 

----- Original Message ----- 
From: Susan Harkins <mailto:harkins at iglou.com>  
To: accessd at databaseadvisors.com <mailto:accessd at databaseadvisors.com>  
Sent: Monday, June 02, 2003 2:08 PM
Subject: Re: [AccessD] Update Query - Need to Speed It Up

How long is too long? With 2 million records, and Jet, just how fast do you
want it to be??? :) 
 
And about that blank -- do you really mean a zero-length string or did you
really want Null?
 
Susan H. 



Dear List:
 
I am running an update query on a table with 2,500,000 records and it's
taking just a bit too long for the my and the client's liking.  
The SQL is:
 
UPDATE tblInvoiceDetail SET tblInvoiceDetail.fldInvoiceDetailPPV = """",
tblInvoiceDetail.fldInvoiceDetailVariancePercent = 0;
 
It's setting one field to blank the other to 0.
 
Is there a way to make it run any faster?
 
 
MTIA,
 
Rocky Smolin
Beach Access Software
 
 



  _____  




_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




  _____  




_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030603/04473905/attachment-0001.html>


More information about the AccessD mailing list