Sorry,

misread, miscalculated, misinterpreted.

If the gap is 150.000 that could also mean that one single user started
(and not ended) one transaction, kept open his application and that this
particuilar transaction is still open for the rest of the day.

And if theres 100 users selling one pair of pants every minute, I don't
thing the number of transactions is very high....

gl,
John


mivi71dk wrote:

> We have on average 100 connections.
>
> Our system is a PoS System.
> This customer has stores where you buy clothes.
> In this chrismas times there is a lot of activity.
> They sell a lot, and they do a lot of statistics.
> The gab grows, when some users is just getting some statistics and previewing them on screen. Sometimes the user just leaves the computer and a transaction is running. If they do nothing, the program will after an hour close down the application (closing querys, commit transactions and disconnecting).
>
> Michael
>
>
> --- In firebird-support@yahoogroups.com, John vd Waeter <john@...> wrote:
>>> Which is 600.000 a day.
>>> Which is 25.000 an hour.
>>> Which is near 416 a minute.
>> > Is this a lot, a little or ?
>> > What is the normal value, if one can talk about normal?
>>
>> If you have 200 users thats 2 a minute per user.
>> If they update databases with sold houses, they sell a lot of houses...
>>
>> IOW, hard to say if not known what the db is used for.
>>
>>> BTW - Duing the day, the gab between transactions here is somewhere between 1 and 150.000. And when the last one disconnects at night, its always down to 1.
>>>
>> That means the transaction-handling in the clients at least finishes all
>> transactions.
>>
>> However, if the gap is abt 150000 and you have 200 users, then that is
>> (average) 750 open transactions per user... looks a lot to me! No
>> problem if user 1 does not need data committed by user2, but again, hard
>> to say if it is not known what your db is used for and how many users
>> are connected.
>>
>> John
>>
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>

--
John vd Waeter
www.jvdw.nl
www.gps-carpool.net
www.shotinthedark.nl
www.pdaforms.nl
www.dbapocket.nl

john@...