View Single Post
  #2  
Old 06-25-2007, 02:59 PM
mike mike is offline
Administrator
 
Join Date: May 2007
Posts: 288
Send a message via AIM to mike Send a message via MSN to mike Send a message via Yahoo to mike Send a message via Skype™ to mike

I have encountered some errors while doing this due to some tables/objects being so large that the php scripts are timing out and cannot finish their downloads from Salesforce.com. Each table download has its own script and, as I have stated before, some of data in these tables have large values.

An example of the problem lies in the Opportunity object, which has over 50,000 records, with 40 plus columns. You can imagine the amount of data that is being downloaded. If the scripts are not written properly, your script will timeout

I am going to continue to develop these scripts and see if I can get a clean run without a timeout over a weeks time. If the scripts can run for a week, multiple times a day (so the data in the locale Oracle database will remain fresh) and run without any such error or timeout that may occur

Mike
Reply With Quote