Re: [firebird-support] Foreign Key & Query Performance

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

Show query plans for both situatios fk an index.


Regards,Karol Bieniaszewski
 Oryginalna wiadomość Od: "antoedinchar...@gmail.com 
[firebird-support]"  Data: 24.02.2018  11:40  
(GMT+01:00) Do: firebird-support@yahoogroups.com Temat: [firebird-support] 
Foreign Key & Query Performance 

 



  



  
  
  Hello there,I am having a doubt that if Foreign Key reduces Query 
Performance Or not.
My Environment is FirebirdCS2.6 :-Item Table :- 10 Records, PK - Itemcode 
Varchar(5);BillDetail Table :- 10 Million Records (FK Selectivity - 0.0076, PK 
Selectivity - 0.00076)
I am having FK between BillDetail.Itemcode And Item.Itemcode with FK every 
query is slow. but as i remove the FK and added Index with 
Itemcode_PK the queries are running lightning fast. But I prefer FK 
to be in Database with high performance queries.
Kindly share you suggestions and Feedbacks on the same.



 

[firebird-support] Foreign Key & Query Performance

[antoedinchar...@gmail.com [firebird-support]]

Hello there,
 I am having a doubt that if Foreign Key reduces Query Performance Or not.
 

 My Environment is 
 FirebirdCS2.6 :-
 Item Table :- 10 Records, PK - Itemcode Varchar(5);
 BillDetail Table :- 10 Million Records (FK Selectivity - 0.0076, PK 
Selectivity - 0.00076)
 

 I am having FK between BillDetail.Itemcode And Item.Itemcode with FK every 
query is slow. but as i remove the FK and added Index with 
Itemcode_PK the queries are running lightning fast. But I prefer FK 
to be in Database with high performance queries.
 

 Kindly share you suggestions and Feedbacks on the same.
 

[firebird-support] Firebird SQL 3.0 login from legacy tools?

[Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]]

Hi,

New Windows 2016 server with Firebird 3 SuperServer x64 on port 3050.

I'm trying to connect to this server from two legacy tools: Sinática 
Monitor and FlameRobin. I can successfully connect with Upscene Database 
Workbench and Firebird Maestro, but the old tools fail, saying "Your 
user name and password are not defined. Ask your database administrator 
to setup a Firebird login."

I have set firebird.conf as follows, and thought that would be sufficient:

AuthServer = Legacy_Auth, Srp, Win_Sspi
AuthClient = Legacy_Auth, Srp

For each connection attempt, firebird.log shows a message like this:

INET/inet_error: read errno = 10054, client host = HOSTNAME, address = 
127.0.0.1/49652, user = LoggedInWindowsUser

What could be amiss? I've tried "reading around" but found nothing. :-)

Feel free to reply here, as an alternative (I think the forum should 
move there, actually):
https://superuser.com/questions/1297659/firebird-sql-3-0-login-from-legacy-tools

Regards,
Kjell
-- 

Marknadsinformation logotyp

Kjell Rilbe
Telefon: 0733-44 24 64

Marknadsinformation i Sverige AB
Ulvsundavägen 106C
168 67 Bromma
www.marknadsinformation.se 
08-514 905 90

Företagskontakt.se 
Personkontakt.se