[ic] Using MyODBC to update MySQL tables

Ed LaFrance edl at newmediaems.com
Mon Dec 8 10:28:32 EST 2003


At 07:01 AM 12/8/2003 -0600, you wrote:

>On Friday, December 5, 2003, at 07:32  PM, Ed LaFrance wrote:
>
>>At 05:31 PM 12/5/2003 -0600, you wrote:
>>>We're changing the way we update our products database. The old way was 
>>>to upload a new products.txt and remove products.sql. The new way we're 
>>>trying is using MyODBC to do updates on the products database directly. 
>>>This is really helpful for us since we are syncing Interchange with a 
>>>point-of-sale system, and updates are a lot smaller than sending the 
>>>whole file each night.
>>>
>>>I'm wondering if there could be any problems with using this method. Say 
>>>the update fails halfway, is products going to be ruined?
>>>
>>>Anyone have experience with this?
>>>
>>>Thanks,
>>>Josh
>>
>>I've had one or two clients do this and they never reported a problem 
>>with it. If you enable logging in the MyODBC control panel, you'll see 
>>that is it simply issuing SQL statements to your server, and I would 
>>assume there is ak-start-end-ak stuff around each one, so I think your 
>>are pretty well covered as far as individual records go - but that is not 
>>from first-hand experience.
>>
>>- Ed L.
>
>Thanks Ed and Doug. Sounds pretty safe, but I will be backing up the 
>database, just in case. :)
>
>Ed, with your clients doing this, do you export products to the text file 
>at all? (Admin -> Tables -> Export) I did this to start out with, and it 
>generates the files for my indices as well. I'm just wondering if this is 
>something I should do regularly. (Maybe those are only for file-based 
>searches?)
>
>Josh

In the normal course of events, there is very little reason to export your 
tables to text files unless you have something specific that you need to do 
with them (or, as you said, you are doing text-based searches on them, 
though most SQL dbms can get you equivalent or better performance than that 
technique).

- Ed


===============================================================
New Media E.M.S.              Technology Solutions for Business
11630 Fair Oaks Blvd., #250   eCommerce | Consulting | Hosting
Fair Oaks, CA  95628          edl at newmediaems.com
(916) 961-0446                http://www.newmediaems.com
(866) 519-4680 Toll-Free      (916) 961-0447 Fax
=============================================================== 



More information about the interchange-users mailing list