[firebird-support] RE: Unecessary reads when update referenced table ?
Firebird itself doesn't access dependent tables if FK value was not changed by UPDATE statement. Do you have UPDATE triggers ? Regards, Vlad
RE: [firebird-support] RE: Unecessary reads when update referenced table ?
The triggers only modify current record on update. I’m not 100% sure it is the dependant tables that the indexed reads do read … but it seemed a semi-logical explanation since my update does a natural scan … if this weird behavior is only happening in my databases I will try to find some time to make a test database with minimum data so it could be reproduced by anyone …. Or I maybe will find what is wrong with my databases. Thank you, Evelyne De : hv...@users.sourceforge.net [mailto:hv...@users.sourceforge.net] Envoyé : 23 octobre 2013 03:40 À : firebird-support@yahoogroups.com Objet : [firebird-support] RE: Unecessary reads when update referenced table ? Firebird itself doesn't access dependent tables if FK value was not changed by UPDATE statement. Do you have UPDATE triggers ? Regards, Vlad
[firebird-support] Modify Existing FDB
Would like a pointer to a guide for modifying an existing FDB without having to rebuild from scratch. For example, adding one or more tables, perhaps linked with FK relationships to existing tables, adding fields to an existing table, increasing lengths of fields of existing tables, etc. What is allowed/disallowed? Thanks, jwc from iMac
[firebird-support] Accessing Firebird database from a DOS Computer
Hi all, Can someone help I have 230 DOS machines that I need to connect to a Firebird database Is this Possible? At the moment I have a "bridge" app that takes FOR EVER to update the database (ideally I would like each DOS machine to update the database directly) Can this be done from DOS? Andy
RE: [firebird-support] Accessing Firebird database from a DOS Computer
Andy, You are out of luck. I don't think there was ever a DOS client software that was released. There was a 16 bit Windows 3.1 client but that wouldn't work with DOS applications. How does your "bridge" tackle the problem? Perhaps we can suggest a different approach. Sean From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Andrew Gable Sent: Wednesday, October 23, 2013 12:14 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] Accessing Firebird database from a DOS Computer Hi all, Can someone help I have 230 DOS machines that I need to connect to a Firebird database Is this Possible? At the moment I have a "bridge" app that takes FOR EVER to update the database (ideally I would like each DOS machine to update the database directly) Can this be done from DOS? Andy
RE: [firebird-support] Accessing Firebird database from a DOS Computer
at the moment it reads in txt files from the DOS apps and then does the database work the problem is if the DOS app crashes or errors out it will completely crash the bridge app With the 3.1 client would that have been a ODBC interface? Andy From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Leyne, Sean Sent: 23 October 2013 6:04 PM To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] Accessing Firebird database from a DOS Computer Andy, You are out of luck. I don't think there was ever a DOS client software that was released. There was a 16 bit Windows 3.1 client but that wouldn't work with DOS applications. How does your "bridge" tackle the problem? Perhaps we can suggest a different approach. Sean From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Andrew Gable Sent: Wednesday, October 23, 2013 12:14 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] Accessing Firebird database from a DOS Computer Hi all, Can someone help I have 230 DOS machines that I need to connect to a Firebird database Is this Possible? At the moment I have a "bridge" app that takes FOR EVER to update the database (ideally I would like each DOS machine to update the database directly) Can this be done from DOS? Andy No virus found in this message. Checked by AVG - www.avg.com Version: 2014.0.4158 / Virus Database: 3614/6772 - Release Date: 10/22/13
[firebird-support] Firebird 2.5 backup takes 2 hours (1 minute in 2.0)
I am working with Firebird from 1.5 many years ago. I migrated Firebird databases from 2.0 to 2.5.2 some month ago. In general works fine, but I see that it is slower in some SQL consults, maybe 20% more. I can see it our test units but it is not critical. The big problem is when sometimes, not always, the user does a backup. It can take 2 hours for a 250MB database. The same operation in FB 2.0 takes 1-2 minutes in 2.0. It is not my PC because it is happening in all our customers around the world: different hardware, operating system, etc. It seems that in network mode, it does not happen, only happen sometimes when the connection is in local mode. Has somebody have the same problem? Thank you
Re: [firebird-support] Accessing Firebird database from a DOS Computer
Odp: [firebird-support] Modify Existing FDB
Hi, Firebird have documentation like release notes. Read it there is all you need. Go to firebirdsql.org and download doc to Fb version you have. Regards, Karol Bieniaszewski - Reply message - Od: "John W. (Jack) Cane" Do: "Firebird Support" Temat: [firebird-support] Modify Existing FDB Data: śr., paź 23, 2013 17:58 Would like a pointer to a guide for modifying an existing FDB without having to rebuild from scratch. For example, adding one or more tables, perhaps linked with FK relationships to existing tables, adding fields to an existing table, increasing lengths of fields of existing tables, etc. What is allowed/disallowed? Thanks, jwcfrom iMac