Odp: [firebird-support] Connection rejected by remote interface

Hi, I saw this error when someone install Interbase over Firebird. But i suppose this is not the case Regards, Karol Bieniaszewski - Reply message - Od: "Aldo Caruso aldo.car...@argencasas.com [firebird-support]" Do:

[firebird-support] Odp: Why backlash do not raise parser error

Hi, I see that it is not sql problem only connectivity problem. Delphi Firedac remove it before executing. Regards, Karol Bieniaszewski - Reply message - Od: "liviusliv...@poczta.onet.pl" Do: Temat: Why backlash do not

[firebird-support] Why backlash do not raise parser error

Hi, Why backslash does not raise parser :error? E.g. Select * from rdb$relations\ R Inner join rdb$relation_fields rf on rf.rdb$relation_name = r.rdb$relation_name\ Where 1=1 Try first line only or whole sql. Interesting that mssql also does not raise exception. It have some reserved

[firebird-support] Foreign key different field type

Hi, Can someone show me example when it is usefull to have different field type in relation Sample Create table test1 (id smallint not null primary key) Create table test2 (id1 integer) Alter table test2 Add foreign key (id1) references test1(id) Why this is not forbidden? Regards, Karol

Odp: [firebird-support] Deletion of rows from multiple tables takes a lot of time around 30mins

Hi, For me 5 minutes looks also very long. Look how delete query plan looks like Regards, Karol Bieniaszewski - Reply message - Od: "Joje j...@codework-solutions.com [firebird-support]" Do: Temat: [firebird-support]

[firebird-support] Interbase vs Firebird

Hi, I got info from Embarcadero ;-) https://www.embarcadero.com/products/interbase/compare/interbase_firebird Yes i know this is sales advertisement. And if we compare what Firebird have and Interbase have not ... But there is some performance/scaling problem showed and i am interested about

Odp: [firebird-support] Firebird 1.5.3 on Windows 2012 R2 Server

Hi, I know only one - cache problem Windows can eat too many RAM. Fixed in FB2.5 serie. Migration to 2.5 does not require 2.1 between. Buf you can get migration errors like ambigous field names and other Regards, Karol Bieniaszewski - Reply message - Od: apos;Softtech Supportapos;

Odp: [firebird-support] Procedures and Triggers missing

Hi, Do you have sysdba and default masterkey? If yes, then change it. Maybe someone else is connecting to your database without permission and do some strange work Regards, Karol Bieniaszewski - Reply message - Od: Chris Valentine chrisvalentinem...@gmail.com [firebird-support]

Odp: [firebird-support] Re: Firebird 2.52 gbak fails to do a restore - error trigger (3)

Hi, Look into firebird.log about errors and into windows events. First check port number and check if Interbase is not running and block Firebird port. Remember that Firebird 3 is in beta stege, and is not for production db Regards, Karol Bieniaszewski - Reply message - Od: Jack Mason

Odp: [firebird-support] Firebird migration to increase perfomances

Hi, 1. Increase your db cache in db or firebird config as i see reads from disc instead of cache 2. Put sql in mesage body Regards, Karol Bieniaszewski - Reply message - Od: apos;Stefapos; s...@autotech.co.za [firebird-support] firebird-support@yahoogroups.com Do:

Odp: [firebird-support] Proper way for copy data from big table

Hi, I am not surprised about skip slowdown I am talking about generic. Something like universal migrator. I can imagine some trick with order by rdb$db_key but this solution can work with Firebird/Interbase but is not avaiable for other servers. If table key is not single field then this is not

Odp: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

Hi, Maybe wrong direction But set this restored with error database to be a readonly and try to connect to it Regards, Karol Bieniaszewski - Reply message - Od: Jack Mason jackma...@mindspring.com [firebird-support] firebird-support@yahoogroups.com Do: firebird-support@yahoogroups.com

Odp: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

Hi, Maybe another wrong direction, But download snapshot build of FB2.5 And extract from there gback file. Do backup with them and try to restore Regards, Karol Bieniaszewski Wysłane z mojego HTC - Reply message - Od: Tim Ward t...@telensa.com [firebird-support]

Odp: [firebird-support] Database restore speed with IBExpert and Gbak

Yes, full restore of normall database with indexes, keys ... and on the same computer os hardware is the same. All 64 bit with 256GB Ram Regards, Karol Bieniaszewski - Reply message - Od: apos;Thomas Steinmaurerapos; t...@iblogmanager.com [firebird-support]

Odp: [firebird-support] Re: losing connection with server on a local PC

Hi, Maybe first check db with gfix against corruption Regards, Karol Bieniaszewski - Reply message - Od: hv...@users.sourceforge.net [firebird-support] firebird-support@yahoogroups.com Do: firebird-support@yahoogroups.com Temat: [firebird-support] Re: losing connection with server on a

Odp: [firebird-support] Database restore speed with IBExpert and Gbak

Possible further enhancements during index re-creation would be to re-create several indexes in parallel becoming more and more IO bound, especially with low latency storage. AFAIK InterBase added something like that in a recent version. Potentially Firebird has that on the roadmap as well.

Odp: [firebird-support] Performance diff between insert...select and for select ... do?

Hi, Why not merge? Regards, Karol Bieniaszewski - Reply message - Od: Kjell Rilbe kjell.ri...@datadia.se [firebird-support] firebird-support@yahoogroups.com Do: firebird-support@yahoogroups.com Temat: [firebird-support] Performance diff between insert...select and for select ... do?

Odp: [firebird-support] How To Display Null Values At the End For More Than One Columns Specified in Order By Clause?

Hi, Following stackoverflow i see that this is not what you show us in sample table results Regards, Karol Bieniaszewski - Reply message - Od: Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] firebird-support@yahoogroups.com Do: firebird-support@yahoogroups.com

Odp: [firebird-support] Cumulative queries

Hi, This look for me like wrong design. Query running minutes are not acceptable from my POV. I do not know how your system work, but in any stock system i see month work. Month is closed and data are calculated and stored. And in next month the same Regards, Karol Bieniaszewski - Reply

Odp: [firebird-support] Re: Is there still a difference between sweep and gabage collection?

Hi, 1. Is this VB exe or web? 2. Save all insert statement parameters to tabbed csv and you will see at what statment it stop. If this is always at the same statement, then compare it e.g. in excel withprevious statements. Regards, Karol Bieniaszewski - Reply message - Od: SUKHEN

Odp: [firebird-support] Re: Speed issues

Hi, Yes i know that, But if he have some permanent connection to this db, then is the chance that next day when he run some query, some data are already in cache. And with bigger cache, is then bigger chance to same data in cache. I use permanent connection on my server, where data are accesed

Odp: [firebird-support] Big database optimization

Hi, What kind of server Superserver or classic or superclassic And how big is that cache settings? Regards, Karol Bieniaszewski - Reply message - Od: zilez2...@yahoo.com [firebird-support] firebird-support@yahoogroups.com Do: firebird-support@yahoogroups.com Temat: [firebird-support]

Odp: [firebird-support] Re: FB 2.5.3 32bit and Db size limits test

Hi, Can you provide source code with this insert action / also dfm I have Xe7 and i can test this About FB on DC this is one hell with Exchange. And it is much bigger problem if you have older version of FB then 2.5.3 (may be 2.5.2 fix i do not remember) on Win2008 with bigger then 4GB RAM

Odp: [firebird-support] Re: FB 2.5.3 32bit and Db size limits test

Hi, Do you use firedac cached updates? I suppose that problem is not Fb. What happened when you close your app and continue inserting? Db process this data or still 2GB limit? Regards, Karol Bieniaszewski - Reply message - Od: af_12...@yahoo.com [firebird-support]

Odp: [firebird-support] How to rebuild all stored procedures / triggers

Hi, This is not nescessary until you change only body of procedure. If you change params then this is another story ... Regards, Karol Bieniaszewski - Reply message - Od: Roland Turcan k...@rotursoft.sk [firebird-support] firebird-support@yahoogroups.com Do:

Odp: [firebird-support] FB server installation and concurrent users limits on Windows Server

Hi, Performance with bad configured fb server I use it in many systems from very small to very big db, with small and moderete client count, and from small to very very high loads without problems If you need some numbers, then ask Regards, Karol Bieniaszewski - Reply message - Od:

Odp: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)

Hi, I see 75 buffers - then i suppose you used default config. Increase defaultdbcachepages settings in firebird config and try again with superserver. I do not see other reason for 30 minutes calc.. Regards, Karol Bieniaszewski - Reply message - Od: t...@camalot.ca

Odp: [firebird-support] numeric value is out of range

Hi, Did you run this outside ibexpert? What is exactly error message and code? Try it with flamerobin or fbsql. And then post info. Regards, Karol Bieniaszewski - Reply message - Od: caste...@titelive.be [firebird-support] firebird-support@yahoogroups.com Do:

Odp: [firebird-support] How do I return an accurate COUNT(*) when a JOIN is involved?

Hi, I do not follow whole discussion but what problem you see in Select count(field1 ¦¦ '_' ¦¦ field2) from ... You can include more fields Regards, Karol Bieniaszewski Wysłane z mojego HTC - Reply message - Od: apos;Softtech Supportapos; stwiz...@att.net [firebird-support]

Odp: [firebird-support] How to improve Firebird 2.5.3 Disk I/O on Windows server 2012 R2

Hi, If you use default fb config then i suppose your cache settings is very very small. Change DefaultDbCachePages to value greater then your db size in pages. Then restart server and run test again. You should have fastest response time. I recommend you also 16k db page size for better index

Odp: [firebird-support] Firebird 2.5.3 SS Tuning

Hi, Your big problem is low RAM with 32bit os an FB. Esspecially your sweep can take very very long time if some of your index is bigger than avaiable RAM. And yes upgrade to new server with minimum 16 GB RAM. Your DB is 50GB then the best will be 64. Then backup your db an restore with 16k

Odp: SV: [firebird-support] Firebird Embedded corruptions

Hi, 1. you use old FB version. 2.5.1 is not newest version 2. Please include error message from FB log Regards, Karol Bieniaszewski - Reply message - Od: fabianoas...@gmail.com [firebird-support] firebird-support@yahoogroups.com Do: firebird-support@yahoogroups.com Temat: SV:

Odp: [firebird-support] Select based upon date between two date fields

Hi, First - what error message you get? Regards, Karol Bieniaszewski - Reply message - Od: idea...@yahoo.com [firebird-support] firebird-support@yahoogroups.com Do: firebird-support@yahoogroups.com Temat: [firebird-support] Select based upon date between two date fields Data: pon., wrz

Odp: [firebird-support] SQL Error -104

Hi, Better will be if you include error message instead of code only i think that problem can be with timestamp is your field date or timestamp? And also is your case statement full? Can contain values like 0101? Better will be using substring + PAD instead of case statement Regards, Karol

Odp: [firebird-support] Re: Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to

Hi, Your assumption is wrong that logic is ok. You have problem with one installation probably because this client have havy load but others not. Insert can only couse problem with unique constraint or reference to other tables or trigger on that record Regards, Karol Bieniaszewski -

Odp: [firebird-support] Restore errors - missing FK

Hi, There was two differences. 1. Your query return whole dataset my only missed ent. 2. I add +0 to avoid index usage your query use index in join and that index can be corrupted But empty result say somethink different. Try follow Sean questions. Regards, Karol Bieniaszewski Wysłane z

Odp: [firebird-support] Restore errors - missing FK

Hi, Your query is not good for index error Try Select * from zip_code_account z where not exists(select * from account a where a.account_id + 0 = z.account_id) This will be slow because it not use index but give you the answer Regards, Karol Bieniaszewski - Reply message - Od:

Odp: [firebird-support] Re: database became broken for any reasons

Hi, Delete from mon$attachments excluding current connection After that you are only logged user Regards, Karol Bieniaszewski - Reply message - Od: Markov Dmitri markovdmi...@yahoo.com [firebird-support] firebird-support@yahoogroups.com Do: firebird-support@yahoogroups.com Temat:

Odp: [firebird-support] Re: database became broken for any reasons

Hi, If you have problem with shotdown database then unplug lan cable to have sure ;) Regards, Karol Bieniaszewski - Reply message - Od: markovdmi...@yahoo.com [firebird-support] firebird-support@yahoogroups.com Do: firebird-support@yahoogroups.com Temat: [firebird-support] Re: database

Odp: [firebird-support] Cache Performance Options

Performance Options Data: wt., maj 13, 2014 08:44 Hi Karol, what Windows 2008 memory problem are You refering to that needs 2.5.3?  Thanks Zsazsi 2014-05-13 7:23 GMT+02:00 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support] firebird-support@yahoogroups.com

Odp: [firebird-support] Cache Performance Options

Hi, Your database is not big but your settings are low. Change your FB server to 64bit and increase your dbbuffer or in fbconfig defaultdbcasche setting and use superserver. Check your database data page size. I always set it to 16KB. Your database utylize memory in this pattern: Dbpage size