Re: [sqlalchemy] Speed up bulk inserts

2013-11-13 Thread Achim
and faster. Sounds like a still quite simple, but hopefully much faster solution. Do you agree? kind regards, Achim -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email

Re: [sqlalchemy] Speed up bulk inserts

2013-11-13 Thread Achim
According to http://www.postgresql.org/docs/9.2/static/functions-sequence.html, sequences are non-transactional: Advance the sequence object to its next value and return that value. This is done atomically: even if multiple sessions execute nextval concurrently, each will safely receive a

[sqlalchemy] Speed up bulk inserts

2013-11-06 Thread Achim Domma
tweeks and tricks to speed up inserts having relations, I would be happy to hear them. cheers, Achim -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr

[sqlalchemy] Offset seems to be ignored when using MSSQL

2006-10-26 Thread Achim
and can see, that both cases generate the same SQL Query. Both use TOP 10 but I can see no code for offset=10!? Any hints? I just updated to 0.3 but it did not solve the problem. regards, Achim --~--~-~--~~~---~--~~ You received this message because you

[sqlalchemy] Re: Offset seems to be ignored when using MSSQL

2006-10-26 Thread Achim
the same result for both cases. Achim --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email