On Wed, Jan 17, 2007 at 02:00:32PM +0100, [EMAIL PROTECTED] wrote:
> - Is there a possibility to use SQLObjects to access data of two (or more)
> different DBs at once? This is e.g. the case where you're importing data
> from an external source.
It is possible - every SQLObject method accept a connection parameter.
Open two different connections and pass them as needed.
> - Inserts into a DB are painfully slow when there are many rows.
Then do not use SQLObject for bulk insertion. Use sqlbuilder.Insert().
Search for examples in the archive of the mailing list.
> There
> should be a possibility to queue up the inserts and perform them using a
> single query
Patches will be gladly accepted.
> - Deleting rows is equally slow. From what I can see, there is no
> sresult.destroy() (or something) that would allow deleting many objects
> with a single query.
sqlbuilder.Delete(). Do not forget to clear connection caches -
connection.cache.clear()
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
