Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP and .NET Data Comparison
Message
From
17/01/2006 11:33:56
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
17/01/2006 11:15:21
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro and .NET
Miscellaneous
Thread ID:
01080965
Message ID:
01087575
Views:
28
It might be. There are some little 'cheating' in my real world app really (hard to explain-basically I don't send back whole cursors back but row identifiers).
Another thing I do when I need to 'pass' cursors is to instead use temporary dbc and temporary table/views (I won't go into debate part in .Net it's easier or not:).
Cetin


>Hi Cetin,
>I was playing little bit with your code and found something strange happening ...
>
>Very first run of your code takes 9 seconds to execute ?!
>Next consecutive run 0.410 sec.
>
>At first (when replied earlier today) I tought sql statement run on non indexed table (customers) was causing that delay but then I commented sql statement out of the picture, and let your function run on native table. The same happened ; 9-10 seconds. Second run 0.4 sec.
>
>Then I tried also within my object (with tmp cursor again) . Again the same!
>9 second first run and again consecutive run 0.41 seconds.
>
>Will play little bit more tonight to see if this can be somehow avoided.
>
>
>
>>Hi Srdjan,
>>About your FAQ entry. I didn't check it extensively but still sounded you're doing it longer than what it might be, hope this contributes for some improvement (up to 65000 records):
>
>>
>>
>>select * from customer into cursor crsCustomer
>>oCustomer = Cursor2Obj('crsCustomer')
>>? oCustomer.aRecords[5].Company
>>
>>Procedure Cursor2Obj(m.tcAlias)
>>select (m.tcAlias)
>>oCarrier = createobject('custom')
>>oCarrier.Addproperty('nRecords',reccount())
>>if oCarrier.nRecords > 0
>> oCarrier.Addproperty('aRecords['+trans(reccount())+']')
>> scan
>>   scatter name oCarrier.aRecords[recno()] memo
>> endscan
>>endif
>>return oCarrier
>>
I didn't include structure inclusion, error checking, restoring alias etc but I think this is more feasible (with multiple tables my real world production timings are under a second - never timed really, because the response was instant).
>>Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform