On Mon, Feb 18, 2002 at 10:23:29AM -0600, mbagepll@memphis.edu wrote:
Hi Jim,
Thank you very much. But i want to use Python scripts to write the sql queries and not ZSQL methods. I have my ZODBCA installed and have created a obdc connection to the MS-SQL database. Can i use this (i mean the connection object) some how in the python script and query the database.
Short Answer: Yes, you should be able to. Medium Long Answer: You need to understand the python database interface: http://www.python.org/topics/database/DatabaseAPI-2.0.html Slightly longer answer: You also need to understand how much session creation costs. This varies from server to server, and I do not use this adaptor. But, for some databases, it will be large, and you will not get the session caching that ZSQL provides. Even Longer Answer: 98% of the time, ZSQL is the right way to go. You get better safety at the cost of more complicated marshalling/demarshalling. Performance is hard to estimate in advance, the ZSQL method has more work to do, but has had quite a bit of effort put into it regrading caching issues: I suspect that for most methods it is a wash. ZSQL debugging, absent complicated sql-group expressions is far easier. Don't avoid ZSQL methods just because they "feel" wrong! At least, do both implementations and time them! Jim Penny
--Madhavi
Content-Description: Card for <mbagepll@memphis.edu>