An open-source DBMS platform descended from Interbase.

learn more… | top users | synonyms

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 ...