Re: [SQLObject] Woven+Twisted

[Oisin M. <oi...@en...>]

> Brad Bollenbach wrote:
>
>>> twisted and sqlobject together in a call card top up system running on
>>> a linux server, which has been running without problems for the past 
>>> few
>>> months.
>>>   
>>
>>
>> Interesting, but dangerous. Rest assurred if your system encounters
>> non-trivial load you'll need to rewrite it (by replacing SQLObject
>> with adbapi in Twisted.)
>>
I forgot to mention that the top up system did undergo stress testing 
before
going into the field. I had two seperate clients doing 4 topups per second
continuously for 3 days. Each topup consisted of roughly 5 sql queries
(via sqlobject). So thats 20 queries a second for 3 days. In this time I
encountered no problems at all. This stress test pushed the system far 
harder
then it was every going to be in the field, where the gui could only 
allow staff
to create a top up every two seconds or so. I don't know about you but I
consider that a "non-trival" load.

All the best,

om