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