[SQLObject] Re: Connections And Threads

[Randall S. <ra...@tn...>]

Koen,

This is a bit more difficult for me to tackle, but since no one else 
has, I'll give it a shot.

For updates, you can set sqlmeta.lazyUpdates = True and call syncUpdate 
to issue your update statement(s) at one time.  I do now know if this 
issues a single statement or multiple statements.  Also, having 
sqlmeta.cacheValues=True (default) should help.  Other than that I don't 
know what else you can do.  If performance was too bad, I would consider 
  putting SQLObject on the server side and using RPC of some sort.

Randall


Koen Bok wrote:
> I am creating a point-of-sale client application partly based on  
> sqlobject. The server is just a postgres database server. They talk  in 
> raw sql.
> 
> Performance-wise it is fine. We tunnel the sql over a SSH compressed  
> tunnel. The biggest queries take about 160ms, which is ok. So big  
> queries aren't the problem. But sqlobject tends to generate lots of  
> small queries, and if I could find a way to do those in parallel the  my 
> app would be a lot faster.
>