Performance reading field().value
Thomas Flemming
tf at ttqv.com
Sat Apr 11 14:58:29 CDT 2009
>>
>> I not remember if VNET have such methods,
>> But it SHOULD.
>>
>> We have the same in other Valentina ADKs
>>
>> Vcursor.StringField()
>> Vcursor.LongField()
>> Vcursor.FloatField()
>>
>> Kirill we have such methods in VNET ?
>>
>>
>> Thomas, also check this API REF in wiki:
>>
>> http://valentina-db.com/dokuwiki/doku.php?id=valentina:products:adk:api:api
>>
>>
>> In particular this page
>>
>> http://valentina-db.com/dokuwiki/doku.php?id=valentina:products:adk:api:vcur
>> sor_class:cast_field_methods
>
> I have check sources of VNET, and I see
>
> 1) there is no such methods in VNET.
>
> 2) I see logical mistake in code which can cause performance issue.
> as I see it needs 2-3 days careful work to polish out it.
>
> Please give us few days to improve this.
>
> It will be good idea if you report this into our Mantis.
>
>
Ok, I'll do so.
By the way, I found two other issues:
1) Problem with Blob
I have a Blobfield in a Table:
mTbl.CreateBLOBField("points", 128)
Now I put some data in the field:
Dim bl As IVBLOB = mTbl.Field("points")
bl.WriteData("testdata")
mTbl.AddRecord()
Now I read the data:
Dim count as Integer = bl.DataSize
gives the correct value, but:
Dim s As String = bl.ReadData
only returns the first character of the string I wrote in.
2) FindRange
This very fast and useful function does not work with Float-fields. It gives
very strange results.
mTbl.CreateFloatField("ext_east", EVFlag.fIndexed)
resultSet=mTbl.Field("ext_east").FindRange(False, minwest, maxwest, False )
When I create ext_east as:
mTbl.CreateLongField("ext_east", EVFlag.fIndexed)
it works perfectly.
Must I also put this into Mantis?
Reards,
Tom
--
/****************************************
** Dipl.-Ing. Thomas Flemming
** Software Development
**
** Touratech AG
** Auf dem Zimmermann 7-9
** D-78078 Niedereschach
**
** mail tf at ttqv.com
** fon +49 (0) 7728 9279-206
** fax +49 (0) 7728 9279-29
**
** http://www.ttqv.com
** http://www.touratech.de
**
** ... und immer dem Pfeil nach!
***************************************/
More information about the Valentina
mailing list