Let's say that I have a table containing:
Machine_Name varchar(20)
Config_Name varchar(20)
Work_Date date
The data for one machine may look like this:
Machine_1, Config_1, 01.11.2012
Machine_1, Config_1, 02.11.2012
Machine_1, Config_1, 03.11.2012
Machine_1, New_Config, 04.11.2012 - we have set
Hello,
I have table Invoice (which is header table) and InvoiceItem (which is items
table) and InvoiceID as foreign key in secound table which is reference first
table.
Now, I have some fields which is sum or products of some another columns in
InvoiceItems which is depend of business logic.
Hi all,
I've modified the query with the specified points and thereby put the times,
there is still a difference between Firebird and MySQL but the difference is
getting smaller. Thanks for that.
Are there any other options ?
Firebird (Execution time: +/- 0.878s):
SELECT FIRST 30 SKIP
Hello,
I have table Invoice (which is header table) and InvoiceItem (which is items
table) and InvoiceID as foreign key in secound table which is reference first
table.
Now, I have some fields which is sum or products of some another columns in
InvoiceItems which is depend of business logic.
GSTAT -h will tell you the On-Disk Structure (ODS) version. AFAIK
there is no way to tell what Firebird (point release) version was used
to initially create the database.
If you don't need to know the exact point release, this is how things
are:
Firebird 1.0 - ODS 10.0
Firebird 1.5 - ODS 10.1
Hello Fabiano,
I've tried the first index, only the second index indicates which you give
twice IdItem on. You mean maybe another field?
But with the first index:
SELECT FIRST 30 SKIP 0 tr.NodePosition, tr.IdLink, tr.IdTargetLink,
tr.IdItem
FROM Tree3 tr
inner join article3_1 art on
On Wed, Nov 21, 2012 at 9:19 AM, Stefan Heymann li...@stefanheymann.dewrote:
GSTAT -h will tell you the On-Disk Structure (ODS) version. AFAIK
there is no way to tell what Firebird (point release) version was used
to initially create the database.
Since there is no difference between
Hallo everybody, i try to do something with firebird .NET, and I'm stuck on
this problem.
I'm trying to explain as simple as possible, you should only need a database
table, a trigger and little bits of code to understand my wish.
The table:
A table with this colums:
tabNodeLang
[PK]
Hi All,
I have a firebird 2.1.2 database running on a Windows 2003.
I already have windows xp clients, also windows 7 64 bits profesional, all
logged into the same domain as the server and every one using ODBC conections.
But I want to connect a Win 7 64 bits home basic to that firebird
We have a production database that has an active, but stuck, transaction, which
we can see using Sinatica. The transaction was started by a gbak backup that
was started 3 weeks ago and has not completed. We see the gbak command in Task
Manager; it is not taking any CPU time. We backup this
At 04:50 AM 22/11/2012, Ann Harrison wrote:
On Wed, Nov 21, 2012 at 9:19 AM, Stefan Heymann li...@stefanheymann.dewrote:
GSTAT -h will tell you the On-Disk Structure (ODS) version. AFAIK
there is no way to tell what Firebird (point release) version was used
to initially create the database.
I have table Invoice (which is header table) and InvoiceItem (which is items
table) and InvoiceID as foreign key in secound table which is reference first
table.
Now, I have some fields which is sum or products of some another columns in
InvoiceItems which is depend of business logic.
So,
Hallo everybody, i try to do something with firebird .NET, and I'm stuck on
this problem.
I'm trying to explain as simple as possible, you should only need a database
table, a trigger and little bits of code to understand my wish.
The table:
A table with this colums:
tabNodeLang
I have a firebird 2.1.2 database running on a Windows 2003.
I already have windows xp clients, also windows 7 64 bits profesional, all
logged into the same domain as the server and every one using ODBC conections.
But I want to connect a Win 7 64 bits home basic to that firebird database.
Hi
Do you have any plans to put Firebird and the database drivers and flamerobin
into the windows 8 app store?
Aparantly there are major issues with sideloading in windows 8.
Thanks
H.F.
Do you have any plans to put Firebird and the database drivers and flamerobin
into the windows 8 app store?
Aparantly there are major issues with sideloading in windows 8.
Are you referring to Windows 8 workstations, Surface or RT?
Sean
Hello all!
I've been using firebird for some years, I'm really happy with the
features and performance that it provides.
I'm running into a problem with one server instalation. I have another
10 that do not have this problem, all of them have the same STACK:
UBUNTU 10.04FIREBIRD 2.1.4
Dear friends, my question is:
The components cxScheduler (from DevExpress.com ) use some fields type BLOB!
One field, type RESOURCE_DATA_INFO (devexpress), use just 40bytes for store
your information about data resources of the record.
My question is, How many bytes are store/or used/ in a DB
One field, type RESOURCE_DATA_INFO (devexpress), use just 40bytes for store
your information about data resources of the record.
My question is, How many bytes are store/or used/ in a DB with page site of
16kb and one field BLOB (binary = numbers) in this case, where DevExpress use
just
Sean,
I am referring to windows 8 workstations as well as the pro
version of Surface. NOT the RT version of windows 8.
H.F.
--- In firebird-support@yahoogroups.com, Leyne, Sean Sean@... wrote:
Do you have any plans to put Firebird and the database drivers and
flamerobin
into the
22.11.2012 1:16, Leyne, Sean wrote:
If that size is less than the free space on the data page, then the blob
would be stored with the data, taking only 40 bytes.
I'd say it gonna take 8 bytes per blob id + up to 8 bytes per alignment
(both compressed) + 28 bytes per blob header (uncompressed)
Helen wrote:
Normally, no. But I suspect this thread might be concerned with the problem
that happened with compound indexes in v.2.5.1, that was corrected in 2.5.2.
If you had a database with compound indexes that was created or restored to
2.5.1 you need to do either a full restore or at
22.11.2012 9:46, Maya Opperman wrote:
If you fail to do the rebuild, and you run into the bug, what actually
happens? Do you get some kind of error message that can be recognised by
my software, and added to to tell the end user what to do to fix it?
If you use that database with FB 2.5.1 or
Hi,
Recently we have started noticing problems at many of our customers
where the index on certain tables are either corrupted or inactive.
These are three different scenarios that we have and I hope you can give
me some info on what is causing this.
1. Index's are in the inactive state.2. Index
Hi,
first latest version of FB 1.5 series is Firebird-1.5.6.5026-0-Win32.exe - try
it and you will see if problem still exists
and really you should migrate to most recent major version
Karol Bieniaszewski
--- In firebird-support@yahoogroups.com, rddymanohar rddymanohar@... wrote:
Hi,
--- In firebird-support@yahoogroups.com, Leyne, Sean Sean@... wrote:
I have table Invoice (which is header table) and InvoiceItem (which is items
table) and InvoiceID as foreign key in secound table which is reference
first
table.
Now, I have some fields which is sum or products
first latest version of FB 1.5 series is Firebird-1.5.6.5026-0-Win32.exe -
try it and you will see if problem still exists
and really you should migrate to most recent major version
Agreed. I had an index corruption issue that was only resolved in FB 2.5
Recently we have started noticing problems at many of our customers
where the index on certain tables are either corrupted or inactive.
These are three different scenarios that we have and I hope you can give
me some info on what is causing this.
1. Index's are in the inactive state.2. Index
Recently we have started noticing problems at many of our customers
where the index on certain tables are either corrupted or inactive.
These are three different scenarios that we have and I hope you can give
me some info on what is causing this.
1. Index's are in the inactive state.2. Index
29 matches
Mail list logo