>>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.