If we are going the EXECUTE BLOCK approach, which I agree would be better.
Then, the optimal logic would be:
execute block returns (id integer) as
declare variable Next_ID integer;
begin
ID = 1;
FOR
SELECT ID
FROM Table
ORDER BY ID
INTO
thank you all. I got also another solution, I will post it here maybe will help
someone
with recursive numbers as (
select 1 number
from rdb$database
union all
select number+1
from rdb$database
join numbers on numbers.number 1024
)
select n.number
from numbers n where
--- In firebird-support@yahoogroups.com, patrick_marten wrote:
Hello,
on a customer machine in our internal log I've noticed the following error:
isc_attach_database
EAccessViolation
Accessviolation at address 1004D5EB in modul 'fbclient.dll'. Writing of
address 0044.
It's a
Hi all. I wonder which of these two variants is optimal, the objective
is to select data depending on the input parameters:
1 variant - The selection procedure involves all joins:
SET TERM ^;
CREATE PROCEDURE my_select_proc (
param1 TYPE OF COLUMN table1.field1,
param2 TYPE OF
I have a CPU intensive stored procedure. It only runs occasionally at user
request, and when it runs, my server is busy running the stored proc, and other
users using the same DB notice a severe delay or they even get a not
responding message on my Delphi front end.
I have some loops going on
I'm not sure if this is the correct forum for this, so please let me know if it
should go somewhere else.
I am configuring a new Windows 2008 server (64-bit) to host our Firebird
installation (SuperServer v2.5.2). I have installed FB and it is running fine.
When I installed the latest version
On 30-1-2013 19:41, red_october2009 wrote:
I have a CPU intensive stored procedure. It only runs occasionally at user
request, and when it runs, my server is busy running the stored proc, and
other users using the same DB notice a severe delay or they even get a not
responding message on
Hello, ScottMoon!
Wednesday, January 30, 2013, 10:45:28 PM, you wrote:
S I'm not sure if this is the correct forum for this, so please let
S me know if it should go somewhere else.
S I am configuring a new Windows 2008 server (64-bit) to host our
S Firebird installation (SuperServer v2.5.2). I
* other interesting requests ? to prevent or diagnose quickly problems ?
I sometimes use (well, I don't actually include any ORDER BY, but would if
there were lots of simultaneous activity going on)
select whatever
from mon$statements
where mon$transaction_id current_transaction
order
Hello
to do my monitoring, I want to use a different box than the fb server, a NAS
(synology) but I need only client tools (isql, gbak, ...)
On synology, it's possible to bootstrap/ipkg [1] to get more tools than
normally available but sadly firebirdsql is not in repository (see probably why
Hi Mark,
This is an EXECUTEable proc, returning nothing, so I should not use SUSPEND.
Do (or anyone) have a suggestion as to how I can tell the stored proc to not
bring my server to it's knees for 3 full minutes?
I want FB to be given high(est) level thread priority in the OS, except for
I'm not sure if this is the correct forum for this, so please let me know if
it should go somewhere else.
I am configuring a new Windows 2008 server (64-bit) to host our Firebird
installation (SuperServer v2.5.2). I have installed FB and it is running
fine. When I installed the latest
Hi,
This is an EXECUTEable proc, returning nothing, so I should not use SUSPEND.
Do (or anyone) have a suggestion as to how I can tell the stored proc to not
bring my server to it's knees for 3 full minutes?
I want FB to be given high(est) level thread priority in the OS, except for
this
Unfortunately, Firebird doesn't offer configurable resource pools
Something like Delphi's sleep(1); could be an easy solution without having to
introduce resource pools
Yes Ed,
Delphi's Sleep, or even something like Application.ProcessMessages in MS
Windows.
Just to say to the OS, hey, you can ignore me for a few milliseconds if there
are other requests coming in, if not, keep going.
Suggested command name: PAUSE or PAUSEME
You did not write, which server version you are using and on which
hardware.
FB 2.5.2.26539
I have one intensively used ClassicServer 1.5.6 (...yeah... *am* in
the process of migrating to 2.5.2) running on a dedicated machine with
Windows2003 OS. 4 GB Ram only, which seems
Hi Thomas,
* Garbage collection might kick in here
I have sweep set to manual and I do it every night just before the backup using
gbak. I don't know if that answers your question about garbage collection.
* Updating active indexes takes time as well, especially with a small page
cache.
Hi,
On a Windows server with FB 2.1 I want to try using FB 2.5 for some
purposes, so I want to do a side by side install of 2.5. The installer
asks me to stop the existing 2.1 instances, so I suppose it cannot be
done using the installer?
So how should I do it? get 2.5 zip package and just
On a Windows server with FB 2.1 I want to try using FB 2.5 for some
purposes, so I want to do a side by side install of 2.5. The installer
asks me to stop the existing 2.1 instances, so I suppose it cannot be
done using the installer?
Download the ZIP archive. Then read the file
(André wrote): I have one intensively used ClassicServer
André's suggestion to use classic server on a computer with multiple
processors/cores sounds like the simplest way to circumvent your problem
(provided things work better nowadays, in ancient days we had to set
CPUAffinity to only use
20 matches
Mail list logo