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>