Although this question is probably better asked on the devel list, I am asking
it here since other might benefit from the discussion.
I am thinking of deploying both an 'standard' and embedded SuperClassic engine
on client systems, and wonder what configuration/issues I need to know about.
The
Carlos,
LS Although we deploy standard server installs, there are times when we
LS need to ensure that no external connections (ODBC) can connect to
LS local databases while we perform database maintenance.
Can't you just put the database in single shutdown mode before doing the
Chuck,
Below is an excerpt from a madExcept bug report. Does anyone have any
idea why the FBClient.dll is hanging?
This is code that run many times in a session without problems. The FB DB is
2.52, superserver, local HD installed. The app is desktop app created in
Delphi
XE2. The DB is
LS You missed a key point from Rick's post ... After backup we do a
LS ***test restore*** Obviously, Rick is double checking that the backup is
valid.
missed nothing. Test restore does not differ from usual restore.
It does not differ in functional steps, but in intent.
In the context he
Monday, March 4, 2013, 11:07:12 PM, you wrote:
RD After backup we do a test restore:
RD gbak -v -se server_name:service_mgr -use_all_space -r backup.fbk
RD test.fdb
RD Normally we just delete the file after gbak completes, but I'd like
RD to be nicer to the database server.
I wonder
I am sure I a missing something, just unsure what :)
This is my query:
SELECT *
FROM (
SELECT EMP. ID, ( EMP.SURNAME||', '||EMP.FIRSTNAME ) FULL_NAME,
DEP.department_name DEPARTMENT,
( 0 ) _A
FROM EMPLOYEES EMP LEFT
OUTER JOIN DEPARTMENTS DEP ON DEP.ID = EMP.DEPARTMENTID
Lester,
While I can understand the theory behind some aspects of 'The Cloud', I
don't see how it can work in the case of some of the 'real-time' applications
that we use Firebird for?
With the correct setup, a cloud deployment could be an ideal solution. It
all depends on the pieces of the
So, it is possible that you can get significantly faster disk IO from such a
solution. At last year's MS NA TechEd, several vendors where showing
Windows 2012 Storage Clusters which had Disk IO throughput of 5 *GBytes*
per second!!!
A clarification/correction.
The actual numbers were
Leyne, Sean wrote:
So, it is possible that you can get significantly faster disk IO
from such a solution. At last year's MS NA TechEd, several vendors
where showing Windows 2012 Storage Clusters which had Disk IO
throughput of 5*GBytes* per second!!!
A clarification/correction
All,
We need to perform maintenance work on the storage cluster which the systems
are running on, so they need to be shutdown.
Thanks in advance for your understanding.
Sean
[Non-text portions of this message have been removed]
I tried running a simple query on firebird 2.5 with rfunc64 bit version from
https://portfolio.assembla.com/spaces/audfl_rfunc/documents
I placed the dll in C:\Program Files\Firebird\Firebird_2_5\UDF
Tried to execut this query on ibexpert
'select z(o.unit_price) from orders o'
In order to guarantee a 'live' DB is backed up in a consistant state, we need
to
make sure it is quiesced at backup time.
We need to configure the Storagecraft ShadowProtect backup job to run a
pre-snapshot script that quiesces the Firebird Database, followed by a post-
snapshot script
Do you know what is the cause of this error message and how resolve it?
After a ROLLBACK the message:
'OLE IDispatch 0 de ibeole.TIBOLECommand: violation of FOREIGN KEY
constraint FK_HISTORICOFAC_1 on table HISTORICOFAC number of
transactions per sweep required.'
is showed.
We know
Olaf,
fb 2.1 cs is running
Now I have four tables:
Persons:
ID
Name
EMAIL
ORDER:
ProjectID
PERSON_WHO_GET (references ID from Persons)
STATUS
Projects:
ProjectID
Manager (references ID from Persons)
ProjectSEND:
ProjectID
PERSON_WHO_GET_INFO (references ID from
I would like to add a script that does a DROP EXTERNAL FUNCTION SQRT.
The problem I have is that some of the databases that will run this script
already have the UDF dropped and so the script errors.
Is there a way to run statements like DROP INDEX, DROP EXTERNAL
FUNCTION, etc. in a
Walter,
Karol, currently now I am importing a .DBF table which has more or less
3.600.000 records and it is taking hours.
Back in 1994 I was able to insert 1000 rows/secs into a IB database from an DBF
file.
So, you need to review your import routine approach/coding.
Exporting the .DBF to
Michael,
We have just this night moved an 80Gb DB from one server to another this
night.
And today performance of the DB is slow! So slow it is almost unusable.
Before we switch back I would like some suggestions, which I might not have
considered. But first background.
FIREBIRD:
Luiz,
I just bought other 2(two) new machines. It´s a Dell optiplex 3010, with
windows 7 Pro 32 bits, 4GB RAM.
I installed firebird client 1.56 in that machines.
When I try connect to database from these new machines, it takes a long
time and the queries also are very slow.
It´s not
I already did it. I disabled windows firewall in these machines. The problem
was not solved.
Luiz
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de Leyne, Sean
Enviada em: segunda-feira, 4 de fevereiro de 2013 17:13
Para: firebird-support
I'm working on the migration of a FB1.5 database to FB2.1.
In my FB1.5 database i used an udf trim, but in fb2.1 trim is an FB internal
function.
Note to all, for future reference, do not use UDF names which *could* conflict
with internal functions that may be added. For myself, to ensure
A Client of ours is running on version 2.04 Classic server. There are 40 db's
with about 50 users accessing them at the same time. It is Win Server 2008 64
Bit, 20GB ram and quad core cpu. Every day we need to restart Firebird as it
gets extremely slow for the users to connect, after the
In a table I have records with id's 2,4,5,8. How can I receive a list with
values
1,3,6,7. I have tried in this way
SELECT t1.id + 1
FROM table t1
WHERE NOT EXISTS (
SELECT *
FROM table t2
WHERE t2.id = t1.id + 1
)
but it's not working correctly. It doesn't bring all
I've a legacy system that keeps many old active transactions and old
intersting transactions for a long time. How can I configure firebird.conf
to
support 50 conections on a SuperClassic 2.5.1 and get a better performance
on a Windows Server 16GB ?
Without a change to the behaviour of the
SET,
In a table I have records with id's 2,4,5,8. How can I receive a list
with values 1,3,6,7. I have tried in this way
SELECT t1.id + 1
FROM table t1
WHERE NOT EXISTS (
SELECT *
FROM table t2
WHERE t2.id = t1.id + 1
)
but it's not working correctly. It
Once again, your keen I found an error!
I swear, English is my mother tongue. Although, from the above, you'd never
know it!
Once again, your keen *eye* found an error!
S
David,
My name is David Narváez
I have a problem with my database and i hope you can help me to give a
solution.
tHE problem is the next
SQL Message : -901
Unsuccessful execution caused by system error that does not preclude
successful execution of subsequent statements
Engine Code
Kelly,
always a great place to get help!!
here's what i have data wise:
Tag ID Date
ABC 11 2012
DEF 11 2011
GHJ 11 2010
HHH 22 2012
ZZZ 22 2011
AAA 22 2010
AAK 33 2012
AAD 44 2012
YYY 44 2010
My
Rick,
We are currently running Firebird 1.5 on a physical server running Linux.
Automated server processes have the database password hardcoded.
We are migrating to FB 2.5 on Linux VMs. Since FB only integrates with
Windows Active Directory authentication, does anyone have suggestions on
OK... anyway, if no better option comes up, you could try Wine, see if it
works for your Windows apps http://www.winehq.org/
Windows 3.1 is *16 bit* not 32 environment.
All Firebird releases are for 32 or 64 bit platforms.
I doubt that you will find a 32 bit emulator that will run on a 16bit
Kjell,
I would hope that the new approach would takes 2X natural scan.
How would that performance be?
What new approach are you referring to?
SL The approach I was thinking about suggesting.
2 X time for natural scan would be fair enough. It took 1½ hour to execute an
update using
Robert,
The weird thing is that while the system is slow and the HDD shows at around
100% use in resource monitor, the actually data throughput is about 1 ro 5MB a
sec. This is can be much higher when the system runs normally. This made me
think the HDD might be faulty but all indications
When I specify ORDER BY A_COLUMN DESC NULLS FIRST, the descending index
created on this column is not used and I get 'natural' in plan.
Is there a possibility to use some index when 'nulls first' is specified .
No.
In order for an index to be used for ORDER BY, the sort order much match
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
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,
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
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
Marcin,
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,
Please change my email delivery address from: jeh3...@att.net
to: entropyisr...@yahoo.com
You would do that through the Yahoo Groups control panel, follow this link.
Sean
Then I got
Statement failed, SQLSTATE = HY000
file C:\\DATABASES\FBPORTFOLIO.GDB is not a valid database Use CONNECT
or CREATE DATABASE to specify a database
How do I get over with this error?
Type in a valid OS path...
C:\DATABASES\FBPORTFOLIO.GDB
not
Hello,
I have a problem with the speed of a query in Firebird. The slowness is in the
sorting and distinct.
If I try the query in MySQL then he is one second faster.
Firebird - 1,3s a 1,6s
MySQL - 0,3s a 0,4s
Please post the PLAN used for the query
Sean
Hello,
I have a problem with the speed of a query in Firebird. The slowness is in the
sorting and distinct.
If I try the query in MySQL then he is one second faster.
Firebird - 1,3s a 1,6s
MySQL - 0,3s a 0,4s
You forgot to post the schema/indexes for the TREE table (you posted
I run a test on a small database, around 128MB using Firebird 2.5 64 bit
superserver and the test condition is like these :
1) Put database completely on RAM, set DefaultDbCachePages = 2048 and
FileSystemCacheThreshold = 0
2) Put database completely on disk, set DefaultDbCachePages = 2048
The Firebird project Tracker will be down for maintenance starting at 2000 hrs.
this evening.
The maintenance should take less than 1 hour.
Sean
[Non-text portions of this message have been removed]
Got a msg from SourceForge this morning advising that the 2.5.2 release is
out - wonderful! But can't find anything related to a What's New document
on FirbirdSQL. In fact the website doesn't even show that 2.5.2 is the latest
release so maybe just need to given Helen a few more days.
But
I Recently buied a new server with 48 Gb of memory
Currently my system only use 15 Gb of memory
I want an opinion with values i can change on firebird.conf to use more
memory an chage my performance
Increasing firebird memory is not necessarily required to improve performance.
But
Sugi,
I have a table, let say Tbl1, which structure something like this id_cst int,
id_gd int, qty int.
I want to select from that table, all records that has sum(qty) 0 group by
id_cst and id_gd.
I have 2 options to do that :
1) create a view with a ddl like this :
create view tmp
Looks like this is an OS/settings problem. :S Tried on an other server and it
works fine.
Cannot connect to server under heavy load.
I get connection rejected by remote interface (335544421).
What OS did you test with?
Sean
Cannot connect to server under heavy load.
I get connection rejected by remote interface (335544421).
Is this a bug, ot there is an option in firebird.conft to avoid this?
Firebird.log (FB20 Classic Server)
L3S-4 Wed Oct 24 14:04:28 2012
I/O error for file C:\PROGRAM
The following simple query produces the results below:
SELECT SCHEDULE.DATE_TIME, TEAMS.TEAM FROM SCHEDULE LEFT JOIN
TEAMS ON SCHEDULE.HOME_TEAMID=TEAMS.PRIMARYKEY
***QUERY RESULTS (Showing 'Home Team' Column)***
12/01/2012 TeamA
12/21/2012 TeamB
12/25/2012 TeamC
How do I include
I have query which extract the sales per day from a table
Select EXTRACT(YEAR from DT) as YEARNO, EXTRACT(YEARDAY from DT) AS
DAYNO, SUM(DUE) from CLIENT_INVOICES group by YEARNO, WEEKNO.
It works 100%, but only returns the dates with sales, I need it to also
include
the dates with
Rick,
What is the effective difference between these two key elements
orderings?
ALTER TABLE T ADD CONSTRAINT U UNIQUE (PK, HIGH_MAX_DUP)
ALTER TABLE T ADD CONSTRAINT U UNIQUE (HIGH_MAX_DUP, PK)
The first version is how I normally order key elements, from most unique to
least. Since
Bruce,
I am having problem with the query which is constructed like this:
SELECT S.Column1, S.Column2, STORED_PROC.Column1,
STORED_PROC.Column2 FROM TABLE SomeTable S LEFT JOIN
STORED_PROC(S.UniqueID) ON 1=1 WHERE S.Data = '01.07.2012' AND S.Data
='09.07.2012'
Is S.Data indexed?
If not,
As I'm running my operational procedure, it might flow something like this:
1. Find first Ticket in 'Pending' Status.
2. Work with Ticket.
3. Set Ticket status to 'Complete'.
4. Repeat.
Depending on what you mean by work with ticket, it would seem that you need
to use procedure logic
Ok, so now that we've established that there is such a thing as windows
server 2011 :)...
Actually, it should have been referred to as Windows SBS Server 2011 -- it
correct name.
Can someone let me know if getting the FDB file onto a separate drive from
the OS will address the slow
Roberto,
Firebird 2.5.1
Select Current_TimeStamp - Cast('00:20:00' as Time) From rdb$database;
Select Current_TimeStamp - Cast('00:20:00' as TimeStamp) From
rdb$database;
Dynamic SQL Error
expression evaluation not supported
unknown ISC error 336397244
How can I correctly substract
Hector,
Sounds nice but still cannot connect with
scadcam.cloudapp.net/51160:employees
Is this / to indicate the port firebird uses or for the port to get access to
the
host?
Is scadcam.cloudapp.net:51160 how you connect to the remote cloud?
Doesn't a client need to login/open a
Hector,
The 51160 port is not the firebird port, it is a port used to connect to a
virtual
machine. If you had several virtual machines, you´d use a different port to
communicate to each one.
For example, I connect to the virtual machine -not the database- with
remote desktop using
Christian,
-Original Message-
From: firebird-support@yahoogroups.com [mailto:firebird-
supp...@yahoogroups.com] On Behalf Of christian.moelders
Sent: Thursday, August 16, 2012 7:25 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Howto compile Firebird C-API
William,
I wish to link the root directory of my database to cloud services like
Dropbox
for version control. There is one problem with this though and it is the fact
that the database is stored in a single file that will become to big to work
effectively with this service.
I think you
Kjell,
Trying to figure out a way to do a search/query with decent performance.
Table Master contains roughly 100 million records and table Detail
contains roughly 200 million records.
Unfortunately, this will cause a natural scan of the 100 million
record Master table, and roughly
Kjell,
Trying to figure out a way to do a search/query with decent performance.
Table Master contains roughly 100 million records and table Detail
contains roughly 200 million records.
Unfortunately, this will cause a natural scan of the 100 million record
Master table, and roughly 200
Halim,
Hello All,
How do I get my database current time zone?
I need it in order to calculate database current UTC time.
The database engine doesn't have native functions for this purpose but you
could build* a UDF which would provide these details.
Sean
* There are UDF libraries which
Add those users to the firebird group, or make sure all those programs
use the service manager or tcp/ip connection to attach to the
database. The problem is now that they try to access the database as a
local database (which AFAIK means it behaves as a privately owned
classic server
Good idea, but it is unfeasible for me because the server is remote on
Internet (with very high latency), so I have to create the back ups on the
server, download the file and apply it to my local machine (which has firebird
2.1)
You could copy the v2.1 GBAK executable onto the remote
Kelly,
it gave me something to google using
i settled on:
select t.plantkey, t.mostrecent, t.tagnumber, t.datetested, t.equipmentkey
from reliefd t where t.mostrecent='T' and
t.PlantKey='20030319103909097704' and exists (select 1 from reliefd p
where p.datetested='2005' and
Gary,
I am in the process of moving servers and the restore time of the 53GB
backup is a going to cause a timing problem
I have made a level 0 backup of the database, 53GB, I would like to restore
the level 0 backup in the meantime, and on the night of the server swap do a
level 1 backup
Stephen,
If I set the Firebird Guardian to start automatically, my system refuses to
boot.
The Guardian is not necessary for more recent Windows versions, due to changes
to the Services functionality which supports the automatic restart (within 1
minute) of a service which has ended abended.
Gary,
Does that mean I can do a level 0 restore overnight, and then a level 1
restore tomorrow night?
In other words, is doing this:
nbackup -R mydb.fdb level_0.nbk level_1.nbk
the same as doing this:
nbackup -R mydb.fdb level_0.nbk
nbackup -R mydb.fdb level_1.nbk
Yes.
Sean
how to best implement value Other for car_model?
Turn the relationship between car_model and car_make itself into a many to
many, by adding a car_make_model table. Then relate the car_model(s) to the
car_make(s).
This approach would have a single Other car_model entry (along with an
Other
Rick,
It happens in 2.5.1. How do I file a bug report?
CREATE TABLE TEST_TABLE
(
IDINTEGER,
COMPUTED_COL VARCHAR(6) COMPUTED BY ('FAILED') );
SELECT t.COMPUTED_COL
FROM RDB$DATABASE r
LEFT JOIN TEST_TABLE t
ON r.RDB$RELATION_ID = t.ID
COMPUTED_COL
Alex,
However, it sounds like rebuilding an index cannot require more
space that the database size itself, right?
Correct, in order to build the index, the engine must build and sort a
projection of the index values.
So, if you build an index on a string [say varchar(100)] column which is
Running gbak -c does not create directories when not exists.
How can I force to create directories? I cannot find any gbak swith which can
help.
There is no switch to do that. Nor would I want one.
Performing file system folder operations is not something that gbak should be
doing.
Sean
Alex,
We tracked down the query that generated a 10GB temp file running against
a 1.5GB database. Can anybody explain why the query is not using an index
on PHYSICAL_COPY.COMMIT_NUMBER?
Cause the optimizer decided that the cost of navigating that index was more
than filtering the result set
We create indexes programmatically and we we generate their names based
on their definition, such the columns they index.
If that is the case, why is the name gibberish?
You could create an index which has the name(s) of the source fields (ie.
PK_PhysicalCopy.ID or FK_PhysicalCopy.CopyID or
unsubscribe
Please follow the instructions in the footer of this message to unsubscribe
++
Yahoo! Groups Links
Rick,
A query with a left join to a table with a computed column returned values in
the computed column even though the row didn't exist in the table. All
other non-computed values came back as null, which was to be expected.
Is this a bug, or correct by SQL specifications?
I don't have a
I have a parent table with multiple child tables.
Each child row has a foreign key that points to one row in the parent.
Each parent row must have a child row pointing to it.
Each parent row can have only child from any of the child tables pointing to
it.
The child is created before the
All I really need to do is have all of the queries (there's a dozen or so)
update
when the book is opened, and then run some code on the data when the
updates are complete.
You are talking about building a Excel macro which automatically runs based on
the Workbook_Open event.
That macro
Bart,
The driver box says IscDbc.
That is not a file name as far as I know.
The file I have is C:\WINDOWS\system32\OdbcJdbc.dll
Let's step back.
Let's start by setting up an ODBC DSN -- we will use that to ensure that the
basic connectivity is working.
When you press the Test button on
I'm trying to upgrade a box running ubuntu + firebird that has been running
for a while.
The old box has Ubuntu 8.04 + firebird 2.1.1 SS running on dual core
hardware.
The new box has Ubuntu 10.04 + firebird 2.1.4 SS running on a 8 core
hareware.
I undestand that there are too
Rick,
In case anyone is confused
Count me as one of them!
as to what I'm trying to accomplish, it's an outer
join on line items where both sides match with no NULL items.
If my approach is poor, then I won't have to worry about question about the
exception.
What happens with this query?
If B_TABLE.VALUE2 never contains 'X' and half of A_TABLE.VALUE1 are 'Y'
what would be the cost of executing this statement? A_TABLE.VALUE1 is
indexed and B_TABLE.VALUE2 does not have an index.
Would it be half of A_TABLE rows times all of B_TABLE rows? Or would the
Not Exists statement be
Nathanel,
Create a virtual database maindatabase{
Agent1: host:port:databasename1
Agent2: host:port:databasename2
...
Agentn: host:port:databasenamen
}
and that all, you can use the maindatabase like you query normal database
(but you can't update it, you are responsible to update
Nathanel,
i thing it's a easy thing to do (one or 2 days of developpement?) but that can
add an incredibble feature to firebird ...
Comments like I think it's a easy thing to do... do not show you in a good
light!
You are a relative new member to this community, I think you will find it
Doug,
On 2/29/12 2:50 PM, todderamaa wrote:
Maybe with the possibility of corruption, I should tell him to exclude
the database files from backup entirely and only backup the gbk files
that are created in the evening.
This is the usual way to backup Firebird databases in situations like
Doug,
If Firebird's' classic architecture is being used then each process accessing
the
file can read it. However, it's hard to imagine a read-only file access would
corrupt the file being read.
Perhaps better experts than I can give you a more definitive answer.
We have over 100
Doug,
The NBackup functionality allows a database file to be quiesced (with
changes written to a delta file) to allow for OS level backups to be
performed (thru Lock and Unlock options).
But doesn't that just move the potential conflict to the delta file, leaving
you
with the same issue
Kjell,
I did have some issue with it 1-2 years ago, with a rather large DB.
Some problem with transaction commit during nbackup locked state. I never
had time to investigate if it was really caused by nbackup, but it only
happened in that state...
A review of the project tracker finds that
Thomas,
To quote Dmitry from a few weeks ago (around mid Jan. 2012), the usage of
nbackup in 2.1 with Classic under high load can be problematic. It seems
that there was quite a re-write in 2.5 though.
I believe that his comment was related to the use in creating backup, not in
locking the
I have a Firebird 1.5 database that has grown up to 26.6 Gb. Most of the data
is stored in one single table that holds a memo field. I'm worried about the
size of this table, because as far as I know the maximun table size for
version 1.5 is about 36 Gb and I guess I'll soon get close to this
Woody,
Since you control all the access, why not create an ID table that holds the
next ID for each table instead of relying on the speed of MAX? It's no more
dangerous in a multi-user environment and as a matter of fact, given the
proper attention to locking, is much safer and easier to deal
one year ago i ask advise to optimize this SQL :
CREATE TABLE HASH(
ID INTEGER NOT NULL,
x1_y1 SMALLINT NOT NULL,
x1_y2 SMALLINT NOT NULL,
x1_y3 SMALLINT NOT NULL,
x1_y4 SMALLINT NOT NULL,
x1_y5 SMALLINT NOT NULL
PRIMARY KEY (ID)
);
CREATE INDEX HASH_X1_Y1_IDX ON
From with amount of record in a table it's start to be usefull to have an
index
?
100? 1000? 1 ?
Actually i thing about 200 ? maybe 1000 ?
Adding an index is not about the number of rows/records, it is about the
uniqueness of the index.
Consider, A table with every person in the
Or is this what you're already doing, just that your example was
simplified?
HTH,
Set
yes, of course parametized queries will be more fast, but i don't think they
will change the ratio in the test (it's will simply be more fast for both
variantes)
I would disagree!
Your test was
I am trying to get used to FB and ran
fb_inet_server -a -m
from DOS prompt.
I see it running in the task manager.
I would like to know how to stop it.
Do I have to kill it forcefully or is there any command to stop it?
Here is the BAT file that we use to kill/stop all our Classic
-Original Message-
From: firebird-support@yahoogroups.com [mailto:firebird-
supp...@yahoogroups.com] On Behalf Of Doug Chamberlin
Sent: Friday, January 20, 2012 6:26 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Sizing conversion project - Email found in
I have never used firebird and therefore wanted to know how it fits when
compared to MySQL in terms of:
ANSI SQL compliance
Triggers
Row level (not statement level) before and after insert, update and delete, as
well as database level triggers.
Foreign Keys
Stored Procedures
In all
Stephane,
It is logical for me, since before inserting, it needs to know if
similar record already exists (to be update). Sso, more operations are
being done (more disk I/O) compared to a single insert.
i was thinging than during an update or insert, the engine try first to
insert
Macro,
I find a situation that Firebird's generated code don't run because the
CROSS
APPLY is used. The issue is generated because I need to create a query inside
the where clause. I'll show the code that runs and part of the code that
brings the issue,
Firebird doesn't have any function
Ekso,
I used to use the C++ Builder PDFCanvas to directly create PDF files from
code.
You posted this to the *Firebird* support list; What does this have to do with
Firebird?
Sean
301 - 400 of 417 matches
Mail list logo