perhaps COMMIT and ROLLBACK for multiple transactions that may need to be undone.
On 27 May 2010 11:33, Bob Sneidar <[email protected]> wrote: > Hi Mark. > > That would work too I suppose. I thought about it, but remember that I want > this method to be portable, that is I want it to work no matter what two > databases are used, and no matter what the amount of data is. Importing a > HUGE mySQL database every sync cycle would not be efficient. And once the > sync occurs for the first time, the actual amount of data I will need to > import is minimal. > > Trevor found an issue with sqlYoga where named database objects were > reloading the database schema every time a call was made using the object. > He has fixed that so speeds using sqlYoga are not noticeably any slower than > the native Rev API calls. Thanks again Trevor for getting right on that. > > Because of that my paging method is working really well in conjunction with > sqlYoga. My next big hurdle is issuing one query that will update multiple > records at a time. I know with SQL I can separate multiple commands with the > semi-colon. But I think I read somewhere that I cannot pass a semi-colon to > the Rev API, which will mean I will have to update records one at a time. I > hope that is not the case, because that will make any method I use with Rev > unscalable for large databases. I will have to experiment on that today. > > Bob > > > On May 27, 2010, at 8:47 AM, Mark Wieder wrote: > > > Bob- > > > > Here's another idea: IIRC you've got a remote MySQL database and a > > local SQLite database. How about converting the local one to MySQL and > > then you could issue a single SQL query joining the two databases? > > Seems like that would simplify things, cut down on the amount of data > > transferred, and let you work with smaller recordsets... > > > > -- > > -Mark Wieder > > [email protected] > > > > _______________________________________________ > > use-revolution mailing list > > [email protected] > > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-revolution > > > _______________________________________________ > use-revolution mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > -- ------------------------- Stephen Barncard San Francisco _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
