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 has 4 core developers plus several part 
timers for testing, drivers, etc.


So, very limited resources of 100mln USD pie and very limited 
resources of 110k are ~1000 times different. Embarcadero can hire good 
C++ developer for Android and perform migration of InterBase codebase, 
Firebird Project cannot afford it - all 4 core developers are working at 
Firebird 3.0 and bug fixing of previous versions.



Regards,
Alexey Kovyazin
IBSurgeon
www.ib-aid.com




We hear a lot of complaints about EMB and the Delphi product and it 
all boils down to the notion of not enough resources being applied to 
development and bug fixes.


But they have managed to supply, now, IBLite for both iOS and Android 
with what looks like a full feature set.


How have they done that with what appears to be very limited resources 
and commitment? And what magic might they have pulled off to move the 
server into this arena? Is this not as difficult as we currently 
think? For Firebird?


Regards

Alan McDonald

[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







++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com 

++
Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

* Your email settings:
Individual Email | Traditional

* To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

* To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

* To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

* Your use of Yahoo! Groups is subject to:
http://info.yahoo.com/legal/us/yahoo/utos/terms/

[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 #04: XRD_RC_DATA_VIEW_F.AVG_FWHM_GAN_002 Alias:AVG_FWHM_GAN_002 
Type:DOUBLE PRECISION
Field #05: XRD_RC_DATA_VIEW_F.MAX_FWHM_GAN_002 Alias:MAX_FWHM_GAN_002 
Type:FLOAT
Field #06: XRD_RC_DATA_VIEW_F.COUNT_FWHM_GAN_002 Alias:COUNT_FWHM_GAN_002 
Type:INTEGER
Field #07: XRD_RC_DATA_VIEW_F.MIN_FWHM_ALN_002 Alias:MIN_FWHM_ALN_002 
Type:FLOAT
Field #08: XRD_RC_DATA_VIEW_F.AVG_FWHM_ALN_002 Alias:AVG_FWHM_ALN_002 
Type:DOUBLE PRECISION
Field #09: XRD_RC_DATA_VIEW_F.MAX_FWHM_ALN_002 Alias:MAX_FWHM_ALN_002 
Type:FLOAT
Field #10: XRD_RC_DATA_VIEW_F.COUNT_FWHM_ALN_002 Alias:COUNT_FWHM_ALN_002 
Type:INTEGER
Field #11: XRD_RC_DATA_VIEW_F.MIN_FWHM_GAN_102 Alias:MIN_FWHM_GAN_102 
Type:FLOAT
Field #12: XRD_RC_DATA_VIEW_F.AVG_FWHM_GAN_102 Alias:AVG_FWHM_GAN_102 
Type:DOUBLE PRECISION
Field #13: XRD_RC_DATA_VIEW_F.MAX_FWHM_GAN_102 Alias:MAX_FWHM_GAN_102 
Type:FLOAT
Field #14: XRD_RC_DATA_VIEW_F.COUNT_FWHM_GAN_102 Alias:COUNT_FWHM_GAN_102 
Type:INTEGER
PLAN (A DATA_XRD_RC INDEX (IDX_DATA_XRD_RC1, IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC ORDER IDX_DATA_XRD_RC3 INDEX (IDX_DATA_XRD_RC1, 
IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC INDEX (IDX_DATA_XRD_RC1, IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC ORDER IDX_DATA_XRD_RC9 INDEX (IDX_DATA_XRD_RC1, 
IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC INDEX (IDX_DATA_XRD_RC1, IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC ORDER IDX_DATA_XRD_RC3 INDEX (IDX_DATA_XRD_RC1, 
IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC INDEX (IDX_DATA_XRD_RC1, IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC ORDER IDX_DATA_XRD_RC9 INDEX (IDX_DATA_XRD_RC1, 
IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC INDEX (IDX_DATA_XRD_RC1, IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC ORDER IDX_DATA_XRD_RC3 INDEX (IDX_DATA_XRD_RC1, 
IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC INDEX (IDX_DATA_XRD_RC1, IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC ORDER IDX_DATA_XRD_RC9 INDEX (IDX_DATA_XRD_RC1, 
IDX_DATA_XRD_RC4))
PLAN (A A NATURAL)

Executing...
Done.
0 fetches, 0 marks, 0 reads, 0 writes.
0 inserts, 0 updates, 0 deletes, 127020 index, 960 seq.
Delta memory: -72 bytes.
Total execution time: 14.561s
Script execution finished.
 
If I use DISTINCT

Preparing query: SELECT DISTINCT a.CON_ID, a.* FROM XRD_RC_DATA_VIEW_F a
Prepare time: 3.962s
...
PLAN (A DATA_XRD_RC ORDER IDX_DATA_XRD_RC9 INDEX (IDX_DATA_XRD_RC1, 
IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC INDEX (IDX_DATA_XRD_RC1, IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC ORDER IDX_DATA_XRD_RC3 INDEX (IDX_DATA_XRD_RC1, 
IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC INDEX (IDX_DATA_XRD_RC1, IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC ORDER IDX_DATA_XRD_RC9 INDEX (IDX_DATA_XRD_RC1, 
IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC INDEX (IDX_DATA_XRD_RC1, IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC ORDER IDX_DATA_XRD_RC3 INDEX (IDX_DATA_XRD_RC1, 
IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC INDEX (IDX_DATA_XRD_RC1, IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC ORDER IDX_DATA_XRD_RC9 INDEX (IDX_DATA_XRD_RC1, 
IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC INDEX (IDX_DATA_XRD_RC1, IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC ORDER IDX_DATA_XRD_RC3 INDEX (IDX_DATA_XRD_RC1, 
IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC INDEX (IDX_DATA_XRD_RC1, IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC INDEX (IDX_DATA_XRD_RC1, IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC ORDER IDX_DATA_XRD_RC3 INDEX (IDX_DATA_XRD_RC1, 
IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC INDEX (IDX_DATA_XRD_RC1, IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC ORDER IDX_DATA_XRD_RC9 INDEX (IDX_DATA_XRD_RC1, 
IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC INDEX (IDX_DATA_XRD_RC1, IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC ORDER IDX_DATA_XRD_RC3 INDEX (IDX_DATA_XRD_RC1, 
IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC INDEX (IDX_DATA_XRD_RC1, IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC ORDER IDX_DATA_XRD_RC9 INDEX (IDX_DATA_XRD_RC1, 
IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC INDEX (IDX_DATA_XRD_RC1, IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC ORDER IDX_DATA_XRD_RC3 INDEX (IDX_DATA_XRD_RC1, 
IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC INDEX (IDX_DATA_XRD_RC1, IDX_DATA_XRD_RC4))
PLAN (A DATA_XRD_RC ORDER IDX_DATA_XRD_RC9 INDEX (IDX_DATA_XRD_RC1, 
IDX_DATA_XRD_RC4))
PLAN SORT ((A A NATURAL))

Executing...
Done.
0 fetches, 0 marks, 0 reads, 0 writes.
0 inserts, 0 updates, 0 deletes, 5761198 index, 5 seq.
Delta memory: 121544 bytes.
Total execution time: 0:03:51 (hh:mm:ss)
Script execution finished. 

As you see distinct (3:51 min vs 15sec) really slow down query.  I have 
impression I use all needed indexing as so on. 
That is why I was looking for option where I can select only first row from 
the query:

SELECT * FROM DATA_SUMMARY a
left join
(select first 1 * from DATA_VIEW) as c on c.CON_ID_2=a.CON_ID_1  

unfortunately it doesn't work. 

If you have any other suggestions please let me know. 

Now I see where I was mistaken,

[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







++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com 

++
Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

* Your email settings:
Individual Email | Traditional

* To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

* To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

* To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

* Your use of Yahoo! Groups is subject to:
http://info.yahoo.com/legal/us/yahoo/utos/terms/

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

 http://www.tetrasys.eu





 

 ++

 Visit http://www.firebirdsql.org and click the Resources item
 on the main (top) menu.  Try Knowledgebase and FAQ links !

 Also search the knowledgebases at http://www.ibphoenix.com

 ++
 Yahoo! Groups Links






-- 
Andrzej Grzegorczyk
Email: ag1...@gmail.com