Stan's slow problem -- NEW BUILD of 2.4 b10
Stan Busk
maxprog at mac.com
Fri Jun 2 13:37:36 CDT 2006
Hi,
I have been looking at that but most queries start looking for record
in a date range.
myField.FindRange( True, "03/01/2006", "03/31/2006", True )
is that valid?
or should it be like in the EXPLAIN log (and Kem Tekinay Apr 21, 2005
messages):
myField.FindRange( True, "03/01/2006 00:00:00:000", "03/31/2006
00:00:00:000", True )
Is that format for VDateTime and VDate or VDateTime only?
Also is there a way to SUM a field with that or should I go thru all
VSet records?
And for Count? I don't see in the doc. a VSet.Count but I guess it
exists right?
> Although I think you can rewrite your report to use BitSets instead
> of SQL
> And you can be much faster of 4 second, it seems .
Stan
More information about the Valentina-beta
mailing list