Re: pySQLite Insert speed

(B) is better than (A). The parameter binding employed in (B)
is not only faster on many databases, but more secure.
See, for example,http://informixdb.blogspot.com/2007/07/filling-in-
blanks.html

Thx. The link was helpful, and I think I have read similar things
before-- that B is faster.
So ... I just rewrote the test code from scratch and B is faster. I
must have had something wrong in my original timing.
.

Relevant Pages

  • Re: pySQLite Insert speed
    ... is not only faster on many databases, ... Thx. ... must have had something wrong in my original timing. ... Don't forget, by the way, that your original code was performing the string substitution of the parameter markers into the SQL statement each time the statement was executed. ...
    (comp.lang.python)
  • Re: High security Needs, Cheep Clients, Need Help
    ... I have a new client who needs secure hosting solutions, ... I am hosting web services on the server to provide the interface with the ... MYSERVER\PUBLIC contains all my existing, non-secure, databases plus some ...
    (microsoft.public.sqlserver.security)
  • Re: High security Needs, Cheep Clients, Need Help
    ... The IIS server needs to be locked down to ensure that you don't ... handle backups of the databases such that the data in your secure instance ... I am hosting web services on the server to provide the interface with the ...
    (microsoft.public.sqlserver.security)
  • Re: Lost ability to login to secure database
    ... > to login and cannot open any of my secured databases. ... I assume you know the workgroup file that was used to secure your ... Create a desktop shortcut to open them. ...
    (microsoft.public.access.security)
  • Re: Lost ability to login to secure database
    ... "Joan Wild" wrote: ... >> to login and cannot open any of my secured databases. ... >> secure Access databases. ... Create a desktop shortcut to open them. ...
    (microsoft.public.access.security)