Need DB Help!! Realtime updates from Mssql to Mysql timeout!!

[JWO112]

Integrating our e-com database (mssql) with sugar ... using mysql odbc 3.51 ... works great with 1k accounts / 1k opps, but running into problem when we have full load (130K accounts / 60K opportunities) ... just times out ... have tried several of the "options" settings, but still getting timeouts ... can anyone recommend correct options and/or alternative to mysql odbc?

Also note that we have many custom fields but not a particularly large user group (20-30 average).

Thanks in advance,
-Justin

LAMP Stack
Sugar 5.0.0a

[Angel]

How are you performing the data transfer?

Are you using PHP? Some Windows util? DTS?

[JWO112]

Using MS-SQL with Linked Server (MyODBC 3.51).

Thanks - Justin

[JWO112]

<<Bump>> Any thoughts?!

[Angel]

Hmm...

Not sure why it would be timing out on you..

Are you using batch updates or individual inserts/updates? Perhaps the statements are exceeding the maximum length for an individual statement.

[JWO112]

Individual inserts and updates in real-time... We're considering a batch method in order to solve the issue, but would prefer to keep it real-time.
And it works fine with 2000 Accounts/ 800 Opportunities... it bombs with 130k Accounts/ 60k Opportunities... I don't think it's a syntax error.

Thanks again,
-Justin