see if you can compress it somehow. Peter Benoit <[EMAIL PROTECTED]> wrote: Well it kinda can't be done that way. Essentially they throw a whole new DB at me once a week and ask that the new info be presented immediately. Currently it takes about 15 mins for the new info to appear. -----Original Message----- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 2:00 PM To: CF-Talk Subject: Re: [RE: [database update?]] replace it over FTP at night. this has nothing to do with CF Peter Benoit <[EMAIL PROTECTED]> wrote: It's a whole new access DB -----Original Message----- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 3:08 PM To: CF-Talk Subject: Re: [database update?] do you update the database (SQL statement) or replace the database with new access DB? Peter Benoit <[EMAIL PROTECTED]> wrote: I have an ODBC connection to my access database. Once a week I update that connection with a new database. It seems to take roughly 15 mins or so for that update to take place. Is there a reason for that, and can I shorten the length? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists