Erwin Craps
Erwin.Craps at ithelps.be
Tue Jun 3 00:59:57 CDT 2003
I had many occasions that NULL is faster when using as a filter in a querie. You must set field option empty string to disabled because otherwise you need to filter on both.... -----Oorspronkelijk bericht----- Van: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] Verzonden: dinsdag 3 juni 2003 0:04 Aan: accessd at databaseadvisors.com Onderwerp: Re: [AccessD] Update Query - Need to Speed It Up Zero length string is okay. I could live with null if it went faster. Otherwise it makes no difference. ----- 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/357638b2/attachment-0001.html>