Does all the data need to be accessed at application load? Is there a way you can "chunk" the data up and retrieve it as needed?
Brandon On Tue, Apr 1, 2008 at 12:59 PM, Cameron Childress <[EMAIL PROTECTED]> wrote: > 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 > ------------------------------------------------------------- > > > ------------------------------------------------------------- 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 -------------------------------------------------------------
