Pyro and sqlite3 problem

Sébastien Ramage sebastien.ramage at gmail.com
Sun Dec 2 04:46:05 EST 2007


>         Off hand -- ensure that each remote access runs the entire sequence
> of "connect, cursor, execute, fetch, cursor-close, connection-close"
> rather than trying to, say, create a cursor in one access and then use
> that cursor on a second access...
>
>         Or maybe create one long-running thread to handle the database
> access and use queue objects to transfer the remote access parameters to
> the database thread, then retrieve from a return queue.
> --

thanks you for answer.
Do you think the first solution will be slow? I think I must use
locking to avoid problem.

The second solution seems better and looks like what I wanted to build
at first time, but maybe an ever opened sqlite database isn't a good
thing ?



More information about the Python-list mailing list