[firebird-support] (unknown)

2012-09-14 Thread Alejandro Garcia
http://serkanozg.eu.pn/beliefelephant/jonathanlewis40/";>http://serkanozg.eu.pn/beliefelephant/jonathanlewis40/ [Non-text portions of this message have been removed]

Re: RES: [firebird-support] problem with restore

2012-09-14 Thread Werner F. Bruhin
Fabiano, On 16/09/2012 16:30 How did you get there;-) . Werner

RE: [firebird-support] Re: Can't continue after bugcheck

2012-09-14 Thread Rick Debay
rxsaccessdb (Server)Wed Sep 12 10:28:55 2012 INET/inet_error: read errno = 104 rxsaccessdb (Server)Wed Sep 12 10:29:34 2012 Database: /opt/firebird/db/edi.fdb operation was cancelled internal gds software consistency check (error during savepoint backout (2

[firebird-support] (unknown)

2012-09-14 Thread michael jones
http://www.khanelholey.com/belleducation/geoffreygordon51/";>http://www.khanelholey.com/belleducation/geoffreygordon51/ [Non-text portions of this message have been removed]

Re: [firebird-support] RE: Stored Proc optimisation advice

2012-09-14 Thread Ann Harrison
On Fri, Sep 14, 2012 at 3:44 AM, Maya Opperman wrote: > > > I'd like both reads and fetches, with statistics > >for a run of the subquery that's fast and one that's slow. Did you mean > >that computing one account balance involved forty-seven thousand indexed > >reads? That's some account! > >

Re: [firebird-support] Unsuccessful metadata update,request depth exceeded

2012-09-14 Thread Jesus Garcia
2012/9/14 Josef Kokeš > Hi! > > This is a first for me. When creating a new table on one Firebird 2.5 > installation, I am getting the following error: > > ISC ERROR CODE:335544351 > > ISC ERROR MESSAGE: > unsuccessful metadata update > request depth exceeded. (Recursive definition?) > Hello, th

RE: [firebird-support] RE: Stored Proc optimisation advice

2012-09-14 Thread Maya Opperman
Attributes force write, no reserve >>> Having "no reserve" isn't a good option for a regular read/write production >>> database, because this basically prevents having back record versions on >>> the same page as the primary record version, thus additional page reads

Re: [firebird-support] RE: Stored Proc optimisation advice

2012-09-14 Thread Thomas Steinmaurer
>>> Attributes force write, no reserve > >> Having "no reserve" isn't a good option for a regular read/write production >> database, because this basically prevents having back record versions on the >> same page as the primary record version, thus additional page reads are

RE: [firebird-support] RE: Stored Proc optimisation advice

2012-09-14 Thread Maya Opperman
>> Attributes force write, no reserve >Having "no reserve" isn't a good option for a regular read/write production >database, because this basically prevents having back record versions on the >same page as the primary record version, thus additional page reads are >necess

Re-8: [firebird-support] Restore fails due to "duplicate Value in unique Index"

2012-09-14 Thread Maik Sommer - Finas GmbH
Hello Alexey, copying a database that has no accessing instances is the recommended way, i read. Why is it a database corruption? What happened there? FBFirstAid 2.6 said everything`s fine! Here`s a snippet of it`s LOG: 13.09.2012 13:04:53 INFO: Open database files: A:\ams4database\DB0.FDB 13

Re: [firebird-support] RE: Stored Proc optimisation advice

2012-09-14 Thread Thomas Steinmaurer
Get the statistics on the various runs of the sub-procedure- reads, >>> writes, fetches, and marks. >>> No writes. 47 000 indexed reads. > > >> Lets try that one again. I'd like both reads and fetches, with statistics >> for a run of the subquery that's fast and one that's slow. Did you mea

RE: [firebird-support] RE: Stored Proc optimisation advice

2012-09-14 Thread Maya Opperman
>> >Get the statistics on the various runs of the sub-procedure- reads, >> writes, fetches, and marks. >> No writes. 47 000 indexed reads. >Lets try that one again. I'd like both reads and fetches, with statistics >for a run of the subquery that's fast and one that's slow. Did you mean >that c