RE: [firebird-support] update or insert from in-line query

2018-03-18 Thread Omacht András aoma...@mve.hu [firebird-support]
Hi Hamis, merge is your friend: https://firebirdsql.org/refdocs/langrefupd21-merge.html In FB 2.5 series only insert and update is supported. András From: firebird-support@yahoogroups.com [mailto:firebird-supp...@yahoogroups..com] Sent: Monday, March 19, 2018 7:48 AM To: firebird-support@yahoo

[firebird-support] update or insert from in-line query

2018-03-18 Thread Hamish Moffatt ham...@risingsoftware.com [firebird-support]
Hi, Is UPDATE OR INSERT INTO table-name SELECT ... not supported? I'm using Firebird 2.5.8. thanks Hamish

Re: AW: [firebird-support] Re: Trace not working

2018-03-18 Thread hv...@users.sourceforge.net [firebird-support]
---In firebird-support@yahoogroups.com, wrote : > after correcting the config, I’m still unable to get a trace. Do you have > any further hints? Without config and error message i can do notning Regards, Vlad

AW: [firebird-support] Re: Trace not working

2018-03-18 Thread Köditz, Martin martin.koed...@it-syn.de [firebird-support]
Hi Vlad, after correcting the config, I’m still unable to get a trace. Do you have any further hints? Regards Martin Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Samstag, 17. März 2018 23:11 An: firebird-support@yahoogroups.com Betreff: [firebird-sup

[firebird-support] Page size vs. index depth?

2018-03-18 Thread Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]
Hi! I'm in the process of migrating a database from Firebird 2.5 to 3.0. Since this requires a backup restore cycle, I thought I'd take the opportunity to investigate an increased page size to achieve lower index depths. The database is ~170 Gbyte and a couple of tables contain ~300 million r