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
It is view.
On Mon, Sep 16, 2013 at 12:34 PM, Norbert <
norbert.saint-geor...@sixsigmagreen.eu> wrote:
> > 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_
Have you tried this:
SELECT
DATA_SUMMARY.*,
DVIEW.DATA2,
DVIEW.DATA3
FROM DATA_SUMMARY
LEFT JOIN (
SELECT DISTINCT DATA_VIEW.* FROM DATA_VIEW
) DVIEW ON DVIEW.CON_ID_2 = DATA_SUMMARY.CON_ID_1
I Can't generate thousand of data yet, but if you please try the query. In
the plan, i see it sho
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
>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
> 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
---
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