Hello all
First of all, thanks for the cool SQLObject project. We're using it in a
mid-size cluster (+- 200 CPUs) banking application and so far it's
performing well.
There are, however, some things that I can't figure out:
- 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. Isn't the sqlobject.sqlhub.connection somewhat
global?
- Inserts into a DB are painfully slow when there are many rows. There
should be a possibility to queue up the inserts and perform them using a
single query
- 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.
In all three cases we revert back to plain SQL, which we really wouldn't
want to do.
BTW: we're using SQLObject 7.0 on Debian Sarge with MySQL 4.
Thanks all
Bernhard
Zürcher Kantonalbank
___________________________________________________________________
Disclaimer:
Diese Mitteilung ist nur fuer die Empfaengerin / den Empfaenger bestimmt.
Fuer den Fall, dass sie von nichtberechtigten Personen empfangen wird,
bitten wir diese hoeflich, die Mitteilung an die ZKB zurueckzusenden und
anschliessend die Mitteilung mit allen Anhaengen sowie allfaellige Kopien
zu vernichten bzw. zu loeschen. Der Gebrauch der Information ist verboten.
This message is intended only for the named recipient and may contain
confidential or privileged information.
If you have received it in error, please advise the sender by return e-mail
and delete this message and any attachments. Any unauthorised use or
dissemination of this information is strictly prohibited.
-------------------------------------------------------------------------
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
