[daisy] Re: issue with large amout of documents

[Bart Van den Abeele]

Bruno Dumon schreef:
> Because you would be bypassing the repository abstraction. I'd rather
> see the repository improved than doing these sort of things.

Is it perhaps possible to make a fast version of the query-method.  A 
version that skips the post-processing like ACL and sorting (although we 
could use the sorting of lucene very good!)

All i want is that my query gets executed correctly and lasts no longer 
thant 3 minutes.  It should return only the fields that i selected.

Example that works:

select documentType, $sb_dd_gemeente, $sb_dd_aktenummer, $sb_dd_jaar, 
$sb_dd_datum, $sb_dd_pictures, $sb_dd_betrokkenen_voornaam, 
$sb_dd_betrokkenen_achternaam, $sb_dd_betrokkenen_hoedanigheid where 
FullText('+Maude') and $sb_dd_jaar = '2000' and (documentType = 
'sb_dd_Geboorte' or documentType = 'sb_dd_Huwelijk')

Example that doesn't work (because every documentType has about 10K 
documents):

select documentType, $sb_dd_gemeente, $sb_dd_aktenummer, $sb_dd_jaar, 
$sb_dd_datum, $sb_dd_pictures, $sb_dd_betrokkenen_voornaam, 
$sb_dd_betrokkenen_achternaam, $sb_dd_betrokkenen_hoedanigheid where 
(documentType = 'sb_dd_Geboorte' or documentType = 
'sb_dd_AangifteHuwelijk' or documentType = 'sb_dd_Huwelijk' or 
documentType = 'sb_dd_Overlijden' or documentType = 
'sb_dd_BijgevoegdGeboorte' or documentType = 'sb_dd_BijgevoegdHuwelijk' 
or documentType = 'sb_dd_BijgevoegdOverlijden' or documentType = 
'sb_dd_Supplementair' or documentType = 'sb_dd_BijgevoegdSupplementair' 
or documentType = 'sb_dd_Echtscheiding' or documentType = 
'sb_dd_BijgevoegdEchtscheiding' or documentType = 'sb_dd_Nationaliteit' 
or documentType = 'sb_dd_UitgebreideGeboorte' or documentType = 
'sb_dd_UitgebreideOverlijden')