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