21.04.2012 0:49, unordained wrote:
> Can the load for operations on a single database be shared across CPUs for
> operations not *strictly* affecting said database (not actively selecting/
> updating): temporary-file SORT, calling UDF's, "doing math"?
The database is temporarily "unlocked" for UD
For future reference if someone else encounters this problem.
If you edit /etc/default/firebird2.5 so that the ENABLE_FIREBIRD_SERVER
variable is set to TRUE. Then you can just run sudo service
firebird2.5-super start to run the service without having to reconfigure
the package. This however assum
I realize this isn't official, but what I'm looking at is: http://
www.iblogmanager.com/download/misc/articles/fb25_architecture_comparison.pdf
For SuperServer, it lists SMP as available as long as the connections are
talking
to different databases, serialized if same database. This correlates f
> I think it is likely that your query could be improved. Am I right in
assuming that you want
> there in ALL cases where there is an RPL_PO_ITM to also exist at least
one RPL_POBILL_ITM
> record and that all matching RPL_POBILL_ITM must have COST defined?
No. In all cases for each RPL_PO_ITM.NDC
I tried the queries Sean and Svein suggested, and they didn't throw an
exception. I then ran my original query to compare, and it WORKED.
Is my database haunted? The only thing that could have changed is that
a backup ran overnight which would have collected garbage, and any
transactions that wer
Hello, Nick!
Friday, April 20, 2012, 7:55:09 PM, you wrote:
NU> so the plan is not stored anywhere in the database that I can access?
it is stored only in server memory when procedure being prepared first
time.
NU> what happens is this regard when some clients reconnect and others don't,
NU> di
On Fri, Apr 20, 2012 at 11:55 AM, Nick Upson wrote:
>
>
> so the plan is not stored anywhere in the database that I can access?
>
It might be exposed if you look at the plan of a statement that includes
the
procedure.
>
> what happens is this regard when some clients reconnect and others don't,
On 20 April 2012 16:50, Ann Harrison wrote:
> **
>
>
> 2012/4/20 Jesús García
>
> >
> > >
> > I think is defined when the SP is loaded and compiled for the first use.
> > To force a new plan, may be 2 ways, depending on the server architecture.
> >
> > 1. Superserver, recompile
> > 2. Classic/su
2012/4/20 Jesús García
>
> >
> I think is defined when the SP is loaded and compiled for the first use.
> To force a new plan, may be 2 ways, depending on the server architecture.
>
> 1. Superserver, recompile
> 2. Classic/superclassic. Disconnect and connect.
>
That's right - of course, restart
What are the minimum system requirements for Firebird 2.1 and
2.5 on Windows?
This page
http://www.firebirdsql.org/manual/ufb-about-sysreq.html
lists Windows NT 4.0, 95/98, and Windows 2000. Is that still valid?
Regards
Stefan
El 20/04/2012, a las 15:20, Nick Upson escribió:
> Hi,
>
> I believe that the query plan for a query in an SP is determined at the
> time the SP is defined
> - if so can I access that plan
> - can I force the plan to be recalculated (preferably without stopping
> database access)
>
>
I think
Hi,
I believe that the query plan for a query in an SP is determined at the
time the SP is defined
- if so can I access that plan
- can I force the plan to be recalculated (preferably without stopping
database access)
Nick Upson
[Non-text portions of this message have been removed]
Hi Guys,
The INNO script for Firebird (FirebirdInstall_20.iss) uses 2 files
(vccrt8_Win32.msi & vccrt8_x64.msi) that I've not been able to find. Could
anyone please provide the link where I can download these files?
Thanks very much.
[Non-text portions of this message have been remov
Roger,
Thanks for sharing your personal experience, nothing better than them.
Roberto Camargo.
--- On Fri, 4/20/12, rcrfb wrote:
From: rcrfb
Subject: [firebird-support] Re: why Blob is so slow ?
To: firebird-support@yahoogroups.com
Date: Friday, April 20, 2012, 10:13 AM
--- In firebird-suppo
On 2012-04-20 10:11, Nols Smit wrote:
> I have a case where I extract data with the following SQL:
>
> Select Gender_Name, Race_Name, Fop_Name, count(ID) as Number_2008_2009 from
> V_Register_Fop
> where RegStatus_ID = 1 and Register_RegDate>= '01.04.2008' and
> Register_RegDate<= '01.04.2009'
Den 2012-04-20 11:30 skrev Svein Erling Tysvær såhär:
>
> >Hi,
> >
> >I have a case where I extract data with the following SQL:
> >
> >Select Gender_Name, Race_Name, Fop_Name, count(ID) as
> Number_2008_2009 from V_Register_Fop where RegStatus_ID = 1 and
> >Register_RegDate >= '01.04.2008' and R
>Hi,
>
>I have a case where I extract data with the following SQL:
>
>Select Gender_Name, Race_Name, Fop_Name, count(ID) as Number_2008_2009 from
>V_Register_Fop where RegStatus_ID = 1 and >Register_RegDate >= '01.04.2008'
>and Register_RegDate <= '01.04.2009'
>group by Gender_Name, Race_Name,
Hi,
I have a case where I extract data with the following SQL:
Select Gender_Name, Race_Name, Fop_Name, count(ID) as Number_2008_2009 from
V_Register_Fop
where RegStatus_ID = 1 and Register_RegDate >= '01.04.2008' and
Register_RegDate <= '01.04.2009'
group by Gender_Name, Race_Name, Fop_Name
On Fri, 20 Apr 2012 06:16:58 -, "venussoftop"
wrote:
> --- In firebird-support@yahoogroups.com, Milan Babuskov
wrote:
>>
>> venussoftop wrote:
>> > I was wondering if there was a way to find out if people are using
any
>> > of the FireBird Databases on a given computer.
>>
>> Define "using".
19 matches
Mail list logo