Quoting jpe...@ykksnap-america.com :
> Yes, with a stored procedure the DB does not have to reparse and
> prepare a new plan for every query. This can be a major win. Esp.
> on Oracle.
Does ZSQL allow the use of bind variables? If so and the database has
a correctly sized query cache, there sho
Quoting CERETTO Thierry <[EMAIL PROTECTED]>:
> In "search form" (Page Template), I have created a select field (called
> "select_keys") to select one or more keys words (from MySQl table). On
> submit, with javascript, I fill an hidden field called "ref_fiche" where
> I put a list (JS array) of val
rs the connections Oracle still thinks are
open. FYI just closing the database connection via the ZMI does not
release the idle connections Oracle still sees.
--
Cynthia Kiser
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db
MySQL is a relational database. The ZODB behind Plone is an object
database. You can migrate information from one to the other, but their
isn't a set way to do it. You will need to decide on your
object-relational mapping and then write scripts to make the move. Not
impossible, but it will take som
on did not
work. I could close a connection - and then still use it to talk to my
database. I wasn't really sure enough of those tests to report this as
a bug, but it is vaguely troubling.
--
Cynthia Kiser
___
Zope-DB mailing list
Zope-DB@zope.org
