If I was doing it I would send the application first time with attached xml file. When the application runs for the first time it will read the data from xml.
Thank you David Faynzilberg Software Developer/Analyst TRX 6 West Druid Hills Drive Atlanta Georgia 30329 USA Office: 404 417-7135 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cameron Childress Sent: Tuesday, April 01, 2008 10:49 AM To: [email protected] Subject: [AFFUG Discuss] Large Datasets with AIR? Hello everyone! Finally got onto this email list and it's time to ask a question. I'm setting up a system for a company that requires me to load a very large amount of data into a SQLite database when it is run for the first time. We're talking in the 700k record range. This would only happen once at startup, but the data would be updated over the life of the application. I didn't expect it to work, but just for fun I tried sending it all up to AIR (from CF) all in one huge dataset. Turns out CF doesn't have a problem creating the dataset, but it looks like once Remoting gets ahold of it, so much memory is required that my server falls over. I've also considered sending the data up in smaller chunks. I'm now looking into creating the SQLite db on the server and just sending that up as a file instead. Any other ideas or resoruces anyone has? Most of the information I've found so far via Google has been about paging large datasets, which isn't something I need to do here. -Cameron -- Cameron Childress Sumo Consulting Inc http://www.sumoc.com --- cell: 678.637.5072 aim: cameroncf email: [EMAIL PROTECTED] ------------------------------------------------------------- To unsubscribe from this list, simply email the list with unsubscribe in the subject line For more info, see http://www.affug.com Archive @ http://www.mail-archive.com/discussion%40affug.com/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, simply email the list with unsubscribe in the subject line For more info, see http://www.affug.com Archive @ http://www.mail-archive.com/discussion%40affug.com/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
