Re: [firebird-support] IBLite iOS and Android

2013-09-16 Thread Alexey Kovyazin
Hi Alan, EMB earns about 100mlns of usd per year and has ~500 headcount (may be more, but it was at the times when they published such stats in their presentations after acquiring CodeGear). Firebird Project has funds about 110k of usd per year (24k of them are being paid by IBSurgeon) and

[firebird-support] RE: left join / first row select

2013-09-16 Thread ag1976

[firebird-support] Re: left join / first row select

2013-09-16 Thread Norbert
Preparing query: SELECT a.CON_ID, a.* FROM XRD_RC_DATA_VIEW_F a What is XRD_RC_DATA_VIEW_F?, a table or view ? test: select * from data_summary a join ( select * from data_view group by 1,2,3 ) b on a.d_1= b.d_2 Norbert -- .. TetraSys http://www.tetrasys.eu

[firebird-support] RE: left join / first row select

2013-09-16 Thread Svein Erling Tysvær
Preparing query: SELECT a.CON_ID, a.* FROM XRD_RC_DATA_VIEW_F a Prepare time: 3.338s Field #01: XRD_RC_DATA_VIEW_F.CON_ID Alias:CON_ID Type:INTEGER Field #02: XRD_RC_DATA_VIEW_F.CON_ID Alias:CON_ID Type:INTEGER Field #03: XRD_RC_DATA_VIEW_F.MIN_FWHM_GAN_002 Alias:MIN_FWHM_GAN_002 Type:FLOAT Field

[firebird-support] Re: left join / first row select

2013-09-16 Thread Norbert
Andrzej Grzegorczyk a émis l'idée suivante : It is view. this may be the source of the slowness you describe, it is not normal for so can record. -- .. TetraSys http://www.tetrasys.eu

Re: [firebird-support] Re: left join / first row select

2013-09-16 Thread Andrzej Grzegorczyk
I will check it thanks On Mon, Sep 16, 2013 at 3:17 PM, Norbert norbert.saint-geor...@sixsigmagreen.eu wrote: Andrzej Grzegorczyk a émis l'idée suivante : It is view. this may be the source of the slowness you describe, it is not normal for so can record. -- .. TetraSys