firebird_jimmy wrote:
Hi, I'm jimmy
I have a problem, please help me!
I have a table with 3,000,000 rows record, every row update 1 to 5 times in
one day. The speed of update statement become slowly, about 30
records/second, but insert speed above 1000 records/second.
Is my usage be
Fulvio Senore wrote:
Do you think that this a reasonable solution, or are there better ones?
How about this:
Create ON CONNECT database trigger and read number of connected users
from MON$ATTACHMENTS. If it's larger than what you want, throw an exception.
--
Milan Babuskov
On 2012-06-13 18:56, Thomas Steinmaurer wrote:
The condition could be queried e.g. by a COUNT(*) on the MON$ATTACHMENTS
monitoring table or whatever you want to be included in the condition.
Thomas,
Just by the way: do you know a simple way (a stored procedure with
elevated rights?) to get
On 2012-06-13 18:56, Thomas Steinmaurer wrote:
The condition could be queried e.g. by a COUNT(*) on the MON$ATTACHMENTS
monitoring table or whatever you want to be included in the condition.
Thomas,
Just by the way: do you know a simple way (a stored procedure with
elevated rights?) to get
Signore Fulvio Senore,
If the problem really is to limit the simultaneous connections, if after each
query, you close the connection, this will by his self assure that the
simultaneously connected users will be the minimum. And will bring other
benefits, as minimizing net traffic.
As
Michael Ludwig wrote:
Fulvio Senore schrieb am 13.06.2012 um 22:17 (+0200):
My purpose is very simple. The users can install the program on any
number of computers connected to a Firebird server, and I want to
limit the number of simultaneous connections.
Do you control the server? If you
Il 14/06/2012 12.36, Thomas Steinmaurer ha scritto:
On 2012-06-13 18:56, Thomas Steinmaurer wrote:
The condition could be queried e.g. by a COUNT(*) on the MON$ATTACHMENTS
monitoring table or whatever you want to be included in the condition.
Thomas,
Just by the way: do you know a simple
Il 14/06/2012 12.36, Thomas Steinmaurer ha scritto:
On 2012-06-13 18:56, Thomas Steinmaurer wrote:
The condition could be queried e.g. by a COUNT(*) on the MON$ATTACHMENTS
monitoring table or whatever you want to be included in the condition.
Thomas,
Just by the way: do you know a simple
On 2012-06-14 07:43, technisoft2005 wrote:
2 Crashing server or network. On loading the program
it checks how many connection there are to the database.
And how exactly are you going to do it? That would also solve the main
problem, wouldn't it?
Regards
Tomasz
If there is only one
Vlad,
We have emailed a link to download the mini-dump and lock-print. Please let us
know if this is helps to resolve the issue as it is occurring more frequently
now - about once a week.
Regards,
Anthony
--- In firebird-support@yahoogroups.com, hvlad hvlad@... wrote:
--- In
--- In firebird-support@yahoogroups.com, anthonyjang2012 wrote:
Vlad,
We have emailed a link to download the mini-dump and lock-print.
Just answered to you privately.
Please let us know if this is helps to resolve the issue
Sure.
Regards,
Vlad
--- In firebird-support@yahoogroups.com, Tomasz Tyrakowski t.tyrakowski@...
wrote:
On 2012-06-14 07:43, technisoft2005 wrote:
2 Crashing server or network. On loading the program
it checks how many connection there are to the database.
And how exactly are you going to do it? That
12 matches
Mail list logo