RE: [RE: [database update?]]
Peter, If these guys give you an update once a week they can wait 15 more minutes for the information to be available! Tell them the facts of life. Sometimes users have to be told NO! If they need faster updates let them ODBC into your database more frequently and directly update your tables. 15 minutes is nothing in the grand scheme of things. Wally Randall Date: Fri, 22 Dec 2000 14:05:29 -0500 From: Peter Benoit <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: RE: [RE: [database update?]] Message-ID: <[EMAIL PROTECTED]> 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. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [RE: [database update?]]
Peter, One way to do it would be to create an ODBC connection to a blank database. Then go into that db and link the tables to the database that's being uploaded. Go under FILE -> GET EXTERNAL DATA -> LINK TABLES. Then choose the uploaded database, and select all the relevant tables. Then when the database needs updating you don't have to worry about breaking the odbc connection etc, just replace the database. hth, larry -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- Peter Benoit 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
Re: [RE: [RE: [database update?]]]
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
Re: [database update?]
Depending on how big the database is, if it is not too big why not just loop over each record in the new database and update the old records. Checking in each loop to see of the record is new, if so, Insert it. This is assuming that they do not change the database structure on you. This whole process would be made faster if the database that they feed you was designed to put a timestamp on each record any time a record was added or updated. That way you could just query the database for anything that has a timestamp after your last update. You could make it super easy on yourself by providing the person who gives it to you a url to go to and upload the new database to. The web site would automatically update the database, and the updater would know when the new data is up right away. jon - Original Message - From: "Peter Benoit" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, December 22, 2000 1:38 PM Subject: RE: [database update?] > 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
RE: [RE: [database update?]]
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
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
RE: [database update?]
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
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
