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]

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

Hi,   i test this on virtual machine with Windows 2008R2 and Xeon E5-2680 v2 and result was:     Executing statement... Statement executed (elapsed time: 0.000s). 10899160 fetches, 1051082 marks, 0 reads, 69 writes. 4 inserts, 950001 updates, 0 deletes, 950016 index, 2 seq. Delta memory:

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:

[firebird-support] old CORE-742 for disscussion

Hi,   http://tracker.firebirdsql.org/browse/CORE-742 i do not need to spam tracker then i move discussion to group.   Please disscuss/vote on exception handling mechanism related to udf call. I can only say that crashing engine becouse udf raise exception is wrong at all. This mechanism can

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

<    1   2   3   4   5   6