----- Original Message ----- From: "jimbobob21" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 25, 2004 8:33 AM Subject: [vbhelp] database access for speed
> Hihi all ;) > I've only posted a couple times here, and never with a question. > Today, I'm changing that. I need a bit of a sugestion as to what the > best method of data manipulation would suite me. I'm building a POS > style program for my boss, it needs to track customer info, order > infor per customer, and a bunch more stuff. > I am using an access database to store the data, and am wondering > first, what the best way of grabbing and sending to the database would > be; and second, how/if I should store all the info in memory, or what, > I have a list of between 500-700 customers and am not sure if storing > them in a collection, or array is the best way to deal with the problem. A disconnected recordset would be the best method. You can manupulate the data as a recordset using ADO, and you do not havean active connection to the database. As for updating the database, you really have two choices, SQL or simply updating the recordset and reconnecting up to update the database. The pros and cons, would depend a lot on data volume. If it is a fairly slow stead process, update the recordset. If it is a volume based process, use an update or insert SQL to update the database with the bulk of the sale data in one go. Matt ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
