>Hi All,
>
>I need to allow a user to read data into a table for processing in my app. I dont know how much data he may read in from a 3rd party source but when the application is done it can discard the data, I dont need it once the app is exited. My question is should I use a disk file table or a memory cursor? Is there any concerns about resources if the user reads in a lot of data?
Cursor, definitely. Resoruce usage should be the same, but Visual FoxPro takes care of some details which you would otherwise have to manage yourself - mainly, assigning a temporary name, and deleting the file automatically when you close the cursor.
Both with temporary tables which you yourself control, and with cursors (which also use temporary files), it is possible that temporary files remain on disk when the program or the computer crashes. You should check, now and then, for those temporary files, and delete them.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)