An open-source DBMS platform descended from Interbase.
0
votes
0answers
15 views
Importing data from Firebird to SQL Server 2008 R2 using ODBC
I need to import data from a source table in a FireBird database to SQL Server. Our network admin has created an ODBC connection to the FireBird database. I use SQL Import Data wizard to load data ...
0
votes
1answer
38 views
sort a large table by its primary key and save it back
So I have a large table (>50 million rows) with an auto incremented primary key column, which is filled by a script running on multiple cores. Now, when I do a SELECT, entries are returned 'out of ...
0
votes
0answers
19 views
Migrate from Interbase to MySQL
I need to migrate a big database from Interbase to MySQL, I'd like to have suggestions about free and non-free tools to perform this task.
I've found this one: ...
1
vote
1answer
166 views
Improve performance with the WHERE NOT IN sub-select clause
In the following query, I have to count transactions for each customer. [EDIT]However, I have to exclude from the result set entirely, customers that have a transaction older than one year.
...
1
vote
1answer
68 views
Minimizing Page Fetches
I have a complicated database structure and am trying to use it to retrieve Records based on multiple selection criteria from several tables. As a general rule, is it better to attempt to use ...
1
vote
0answers
120 views
Firebird database performance after server upgrade/restart
Got a 350 GB database (more than 40M records plus 0 - 1000 BLOBs for each record in another table). After upgrading Firebird to version 2.1.5 (mainly because of filesystem cache issue) database became ...
0
votes
1answer
135 views
how to set a column to fetch the date now?
hi i have a sample table named datenow and used the following to create my table on flamerobin to have a column that gets the date today automatically when an entry is added.
CREATE TABLE "DATENOW"
(
...
2
votes
1answer
80 views
how to build table relationships in a firebird database?
I am a beginner in Delphi and I have a Firebird database with 2 tables namely masterlist and daily collection. I used Zeos 7.0.3 to access my Firebird database.
My masterlist contains the following ...
0
votes
1answer
335 views
How do I check if a constraint exists on Firebird?
I'm about to publish a script which will update a lot of Firebird databases all at once. Some will not have this constraint, so I would like to check for the existence of a constraint before I try to ...
1
vote
2answers
101 views
Storing a transaction sensitive constant in Firebird
I'd like to store a number in my Firebird database that indicates the revision of its structure. The number is supposed to be updated only when the structure has successfully been altered by some ...
4
votes
1answer
734 views
Firebird monitoring tables
I am working with a Firebird 2.1.1 database and I started reading about the Monitoring tables.
I am trying to see somehow in real-time what queries does each client performs in the database.
I had ...
6
votes
1answer
715 views
Fixing corrupted Firebird database
I have a 200 GB Firebird database (created with Firebird 2.1.3, currently running 2.1.5), and it appears to be corrupted. When I try to do a backup I get:
database file appears corrupt <>
...
6
votes
2answers
140 views
Minimizing Indexed Reads with Complex Criteria
I'm optimizing a Firebird 2.5 database of work tickets. They're stored in a table declared as such:
CREATE TABLE TICKETS (
TICKET_ID id PRIMARY KEY,
JOB_ID id,
ACTION_ID id,
STATUS str256 ...
5
votes
3answers
391 views
Creating an index in both asc and desc directions
Over the past few weeks I've been raging against an old Firebird database. This database is crappy for all sorts of reasons, but one thing I noticed was that every single field of every single table ...
4
votes
2answers
1k views
No luck trying out Firebird 3.0
Today I though I'd give Firebird 3.0 a shot, but for some reason I can't seem to get it installed - at least not in a way that I can connect from a JDBC application.
What I did was to follow this ...