Op Mon, 3 Jul 2006, schreef [email protected]:
> > On 2006.07.02, Andrew Piskorski <[EMAIL PROTECTED]> wrote: > > > If all you're using MySQL (or any SQL-fronted data persistence > > mechanism) for is key-value lookups, then something like BDB ought to > > win because SQL parse time overhead is not zero. SQL is not "free" in > > that regard. > > Oracle caches parser and planner results ... PostgreSQL too, but, you need to use parametrized queries to take advantage of it, preferably recycle queries between pages. I.e.: SELECT * FROM users WHERE login=:login ... allows the same query to use the same plan with different parameters. To take advantage of it, you must prepare the query once, and then use it. However, in AOLserver programming, the queries are prepared upon use. Note that OpenACS only emulates parametrized queries, it converts them to SQL strings and then uses the normal AOLserver database API. Daniël -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
