Hi Michael,
> Ok, I understand it. The actual version in CVS does not include such
> "tricks" (";" and prepare_cached). I will implement a hash with the
> cashed statements and I will start reading some docs about
> prepare_cached(). Any interest in programming the database interface?
> Looks like you have some experience.
I've done some work on this before, yes. Do you need help? Is it
possible to split up the work?
>> You can store the prepared handles in a member variable for later
>> use. Using 'prepared' statements repeatedly is extremely efficient,
>> it should be even more efficient than using do() or similar.
>> Remember that initially parsing the SQL is expensive, calling the
>> DB on a prepared statement with the appropriate parameters is not.
>
> I don't know do(). So I cannot do something wrong ;)
Good, so don't even look it up in the DBI docs... :-)
>> Oh, and always use bind_param() or execute().
>
> I don't use bind_param because I can give the paramters to execute too.
> Does this be a bad idea?
Nope, no problem. Execute(args) is short for bind_param(args) and
execute(). Only difference is for identical invocations with the
same arguments.
Martin
-------------------------------------------------------
This SF.Net email is sponsored by:
Sybase ASE Linux Express Edition - download now for FREE
LinuxWorld Reader's Choice Award Winner for best database on Linux.
http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click
_______________________________________________
OpenCA-Devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/openca-devel
