Write the page in (PHP, etc.) to return the data in JSON and then write Javascript to fetch the data via beta.httprequest and insert into database. As far as I know, that'd be the only logical way.
Depending on how big each of the million records are, you might have to split it up via limit & offset parameters. You could mess with sqlite files directly if you're deploying only to a few machines, but that's ugly ugly ugly. Cheers Chris On Nov 17, 12:54 am, Murali <[EMAIL PROTECTED]> wrote: > Hi Austin, > > Thanks for the reply. > > Is there a way that I can connect to Online Database and insert that > data into offline database? > > I have more than million records to insert for the first time. > > Appreciate your help > > Thanks > > On Oct 20, 1:02 pm, Austin Chau <[EMAIL PROTECTED]> wrote: > > > Hi, > > > If you were asking whether there is a way to perform file import > > directly into the database via the API, the answer would be no. > > But you can perform the data loading utilizing the transactions > > feature of the Database API. More details can be found in this FAQ > > entry - > > >http://code.google.com/apis/gears/gears_faq.html#bestPracticeDB > > > Essentially, you will be using a worker pool to open database > > connection and create a transaction of all your DB entries. This way > > the user experience won't be impacted as you are loading in large > > amount of data. > > > Cheers, > > Austin > > > On Oct 17, 6:26 pm,Murali<[EMAIL PROTECTED]> wrote: > > > > For the first time users clicks on synchronize, I have to load large > > > volume of records to a local database table. > > > > can you pls suggest me some approaches? > > > > 1] Downloadina large file and then creating a program to reas that > > > file and load to database table > > > OR > > > 2] is there a way to dowload the data directly from server to local > > > database tables > > > > 3] Any other best way > > > > Pls let me know- Hide quoted text - > > > - Show quoted text -
