Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Seeking Opinions On Transactions....
Message
 
To
13/05/2002 15:48:19
Jason Dalio
Northern Interior Regional Health Board
Prince George, British Columbia, Canada
General information
Forum:
Visual Basic
Category:
Other
Miscellaneous
Thread ID:
00655833
Message ID:
00655851
Views:
28
Hey Jason. I can understand the memory concerns about storing the data in arrays etc. But, the temp-table database solution sounds a little kludgey to me. How many items will they really be adding before saving? If it's so much data that there is actually a client memory concern, then I would argue that the bigger concern is with the user losing an hour of entry when his/her PC shuts off! Could you enforce a save-per-fifty entry policy by triggering a Save function when a counter reaches a certain point?

I think the database approach will work, it's just one of those span-architecture-layer approaches that I like to avoid.

HTH.

>Looking to get some input from others who have already done similar things. I have a form with a tab control on it. On these tabs there are multiple TreeView objects. When the user clicks on a node item the corresponding data is called from SQL server and displayed in etxt boxes. The problem I am having is how to store the data when new items are added. I don't want the new items to be added until the user clicks save so I have to temporarily store the data somewhere first. Originally I was using dynamic arrays to store all of the data but I figured these would amass in size at some point and not be efficient. I'm worried that using arrays will suck up too much memory on the client. Alternatively, I could use the arrays to only store the new items but I haven't tried that yet. So now I am thinking about using a temporary table on the server to store the new records, then when the user clikcs save, itterate through the table and do batch transactions with stored procedures for the
>updates. So if you have an opinion or an idea around this I'd love to hear it. Thanks.
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell
Previous
Reply
Map
View

Click here to load this message in the networking platform