Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Long field name bug
Message
From
24/11/2006 08:42:03
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01171727
Message ID:
01172252
Views:
19
>>Well, we may agree to disagree. I use cursors extensibly, especially in my webshop, and if all cursors were written to disk, the response time would increase drastically. One of the big advantages of cursors, is that they reside in memory if possible, and that is why they are so incredibly fast. If given a choice, I would choose the current behavior.
>
>Ho wait, here is some misunderstanding, as I see it. It is my finding that VFPs decission to use the disk is taken very quickly. In tests adding only some records was enough for this. And also you have no clue when exactly this will happen. If for your webshop speed caused by memory-usage is important, then you might be helped more by creating a ram-drive!

AFAIK the amount of available RAM is important. My server has 2GB of RAM.

>>If you really need long field names in a cursor, and if you really need to alter the structure of these cursors, then you can rewrite your code to use temp tables in stead.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform