Re: [firebird-support] Cannot Create Index

How to increase the database page size 16kb ? On Tuesday, 13 October 2015 9:00 PM, "Fabiano Kureck fabi...@sci10.com.br [firebird-support]" wrote:  Maximum key size is one quarter of page size. What is your database page size? What is the

Re: [firebird-support] Cannot Create Index

Just back it up and restore it using gbak and use the - P 16384 parameter to change the page size when restoring it. Regards, Neil Pickles – n...@csy.co.uk - Reply message - From: "Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]" To:

Re: [firebird-support] Cannot Create Index

Thank You. Let me check. On Wednesday, 14 October 2015 11:11 AM, "'Neil Pickles' neil.pick...@csy.co.uk [firebird-support]" wrote:  Just back it up and restore it using gbak and use the  - P 16384 parameter to change the page size when

Re: [firebird-support] invalid request BLR at offset 63 - functions (LTRIM,RTRIM,LRTRIM) not defined - module name/entrypoint not found

> Hello Team, > > A few days back, I posted a message regarding 'Firebird BLR 623 invalid > request - LRTRIM is not defined - > module name or entrypoint could not be found' when I ran some stored > procedures that used either LTRIM > or LRTRIM functions (occasionally,though not always). > >

[firebird-support] invalid request BLR at offset 63 - functions (LTRIM,RTRIM,LRTRIM) not defined - module name/entrypoint not found

Hello Team, A few days back, I posted a message regarding 'Firebird BLR 623 invalid request - LRTRIM is not defined - module name or entrypoint could not be found' when I ran some stored procedures that used either LTRIM or LRTRIM functions (occasionally,though not always). Getting to the

Re: [firebird-support] invalid request BLR at offset 63 - functions (LTRIM,RTRIM,LRTRIM) not defined - module name/entrypoint not found

Thanks Thomas, I unstalled the 64-bit Firebird, and just reinstalled it only with the minimum client files. The 32-bit is untouched, and now the issue is sorted out. On Tue, Oct 13, 2015 at 12:29 PM, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]

Re: [firebird-support] Cannot Create Index

Maximum key size is one quarter of page size. What is your database page size? What is the collation of that field? Try increase database page size to 16Kb Em 13/10/2015 12:20, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] escreveu: Hi All, I am trying to create index on a field

Re: [firebird-support] How can I see which query within a stored procedure execution takes the longest time?

I did it by writing a logging procedure which wrote timestamps to an external file mapped to a text file, then calling it where I was interested. An alternative is Monte Carlo profiling - I've also got a script which polls the call stack from the RDB$ tables. The procedure or statement it

AW: AW: [firebird-support] Optimize query for date ranges

Hello Thomas, the result set contains 3 record for criteria. Records DATUM >= '5.10.2015' = 102 Records DATUM <= '11.10.2015' = 26 It seems that both queries need to be executed and then the subset of matching data for both date conditions is provided. The performance is not my main concern in

RE: [firebird-support] How can I see which query within a stored procedure execution takes the longest time?

Hi Tim, Thanks for the reply. You mentioned that you did it with a logging procedure. Can you share what you exactly what you did to accomplish this? Mike

Re: AW: [firebird-support] Optimize query for date ranges

On Tue, Oct 13, 2015 at 3:47 PM, 'Parzival' parzival1...@gmx.at [firebird-support] wrote: > Hello Thomas, > > the result set contains 3 record for criteria. > > Records DATUM >= '5.10.2015' = 102 > Records DATUM <= '11.10.2015' = 26 > > It seems that both

Re: [firebird-support] Optimize query for date ranges

>SELECT * FROM ARBEITSEINTEILUNG AS a where a.baustelle = '12345' AND >a.DATUM >= '05.10.2015' AND a.DATUM <= '11.10.2015'; > >PLAN (A INDEX (IDX_ARBEITSEINTEILUNG1)) > >there are two indices on the field DATUM: One ascending, the other one >descending. > >Records DATUM >= '5.10.2015' = 102