if table A has a primary key
and table B has a field with a foreign key on A.primary
does that field in table B also need an index or will it use the index for the
primary key?
I remember reading years ago that Firebird would compile multiple indexes based
on the search requirement and that it was better to do indexes that way instead
of creating multiple compound indexes.
eg
Table1 (
field1,
field2,
field3,
)
this is better
Create Index idx1 on Table1 (
I'm building a web app, backend is Firebird, web architecture is MVC, written
in C#.
What are some recommendations for server-side reporting that work well with
Firebird?
Dixon
You might need to show your other triggers before we can help you, But have you
tried moving it to BEFORE instead of AFTER update
Given the following WHERE clause
SubscriberId = :subid
AND ProviderId = :provid
AND IsActive = 'Y'
AND Published = 'Y'
SubscriberId and ProviderId are integers and should be in a compound index.
But IsActive and Published are CHAR(1) fields where the only values are either
'Y' or 'N
The following procedure causes a deadlock when the user on the web page
navigates rapidly through a javascript object on the web page. Please give me
some advice on how best to deal with this. I've thought about changing it
using DATEDIFF so they update only once a minute, but I would apprecia
Session login is is unique between logins, but will be reused by the same user.
I've no doubt that there are two attempts to update the same record. That is
because session login is used to validate the user has permission to write the
record they are attempting to. In the scenario described,
I think you are correct on the 'lock conflict'. After posting the original
message, I started reviewing the error log and noticed several 'lock conflict
on No Wait transaction'. This would make sense as this is a key part of the
security and this procedure is called on every read/write to the
This discussion has migrated to slightly off topic where I should be taking it
up in Firebird-tools. But to close the discussion, here is how I resolved it.
If the choices I've made are not the best, please criticize.
in the C# method that calls FbCommand, I added an optional parameter,
Iso
Jim Not sure from your question which table should be first, but wouldn't
something like this work for you if
either Active_Inventory.product_ID was a Primary Key or both tables have a
unique index on this field?
SELECT a.product_ID, b.product_ID
FROM Active_Inventory a
LEFT JOIN Vendor_
It seems that I read here recently that its better not to install FirebirdSql
in the default Program Files on Windows server 2008R2. I'm getting ready to
deploy my app to the web and wanted some advice regarding this.
Thanks
Dixon
I think it had to do with permissions. It was a passing conversation and I
don't remember exactly what the issue was. But seems like they were getting
blocked on some of the activities because Windows was restricting it to Admin
rights.
Have you tried something like this?
UPDATE Table_1 a SET a.Column = 1
WHERE a.PK IN (SELECT b.PK FROM Table_1 b WHERE "conditon = criteria")
So where is the download for Firebird 2.5.3? I'm on www.firebirdsql.org
http://www.firebirdsql.org/en/downloads/. It says the latest release is 2.5.2.
14 matches
Mail list logo