Well, the base data will change over time. I'd have to be able to bundle a new XML file each time, and would still have to convert that XML file into a database within AIR on first run. I could have it load the XML remotely just as easily, and that could easily be generated on request.
-Cameron On Tue, Apr 1, 2008 at 11:01 AM, David Faynzilberg <[EMAIL PROTECTED]> wrote: > 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 > ------------------------------------------------------------- > > > -- 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 -------------------------------------------------------------
