Hi, ... Change your NOT IN into a NOT EXISTS. See also the release notes from Firebird 2. Regards, Arno Brinkman ABVisie -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- ...
Hi, but reading your link, the superserver seems better than classic and it should allow parallel execution of queries in different connections with the...
Hi1 Is there any reasonable way to change a query inside a stored procedure? What I mean is that I have a procedure like this: CREATE PROCEDURE ReadArticle( ...
Hello Nick, ... Yes, Foreign Key Constraints can "point" to a Unique Constraint, but not to a Unique Index. Martijn Tonies Database Workbench - tool for...
on Firebird 1.5 and 2.0 I have this problem, Table A and table B in relation, on table A there's a field WUPDATE, on A and B a trigger onAfterUpdate setting...
... IIRC, unique indices preceeded the unique constraint. IMO, you should never manually create a unique index. Such an index is implicitly created with a...
Hello, I am running four Firebird Classic 1.5.3.4870 Servers. All of these servers run on Dual Xeon 2.8Ghz Machines one Has 2Gb Ram and runs Windows 2000...
Pepak, I've just moved across from MSSQL to Firebird, and have yet to write a Firebird stored procedure - so I'm not familiar yet with Firebird's syntax, but...
Will, ... these ... I have been having the same problem, with a very similar configuration (FB classic on dual Xeon W2k3 server). How are you detecting the...
We have been taking users on interbase 5.x to firebird 1.5.2 without problems, today we ( by accident ) found one of our users were on interbase 7, we found...
I find large databases always corrupt, I think you need to devise some kind of archive process. Perhaps copy the .gdb away to archive.gdb and then run some sql...
... Yould try extracting the metadata to create an empty firebird database. Then use a tool like IBDataPump to pump the data from IB7 to the new FB database. ...
Hello All, In FB.1.5.xx DELETE FROM TICKETITEMS WHERE TICKET_UNIQUENUM NOT IN (SELECT TICKET_UNIQUENUM FROM TICKETS); executes in a fraction of a second, since...
Hello Jason, ... Reinstall InterBase, do a "backup" with InterBase and a "restore" with Firebird and all should be well (that is: if you didn't use any IB7...
I think you solved it, now FB2 is coming up with good plans. Now the question is, why do all my primary key indices have no statistics computed for them? ...
Rick Debay
rdebay@...
Dec 1, 2006 4:06 pm
81732
... Yes this is probably a bug, and it will be hard to find since it's rare and hard to reproduce. If I had a copy of the database with the broken index, I...
... Have you tried backing up the database with the Firebird 1.5 gbak using the name of the InterBase 7 database running on a system with the InterBase 7...
... I guess we're going to need to see your actual trigger, or better yet a simplified version of it. However, my suspicion is that you're trying to change a...
... I feel that all those errors are related each other (the same table for example ). Could it be that the reason of broken index is something which caused...
Bogusław Brandys
brandys@...
Dec 1, 2006 5:23 pm
81737
We have taken them back to interbase 7 for now, they are sending us the .gdb so we can test it here. I think they were having problems doing backups for some...
I've tried that on table A either in a before and in an after trigger, with the same result, the second call is made with new=0, however have tried it from the...
... The mutex wait is amount of time processes spend waiting their turn to update the lock table. In classic, though we talk about the lock manager as if it...
... My guess is that there's a problem that happens while splitting an upper level index page. Again, guessing, under some circumstances, the page isn't being...
Hi, ... Because you first created all metadata and imported the data after that. I Assume you first created the tables with only the PK's, then filled with...
no, trust me on this one, large databases are not stable, unless your using a very expensive database system archive the data :) ... From: Ann W. Harrison...
... inside the tables. OK, that makes sense. Too bad the engine can't do this on its own. But I guess since it has to be done just once, the burden should...
Rick Debay
rdebay@...
Dec 1, 2006 6:40 pm
81745
... Thanks for the info. I have seen your previous posts and the issues do look very similar. A question for you, do the indexes that go corrupt on you always...
