Inserting large volumes of data into SQLite - speed issues

by Marco Nelissen » Thu, 03 Sep 2009 01:02:38 GMT


Sponsored Links
 Are you using bulkInsert?





--~--~---------~--~----~------------~-------~--~----~



Inserting large volumes of data into SQLite - speed issues

by Gavin Aiken » Thu, 03 Sep 2009 01:10:08 GMT


 Does the data NEED to be on the device? Can it not reside on a server?
Certainly you are better to manage the synchonisation yourself rather than
bundle the 120MB lib for downloading through the marketplace. This sort of
download needs to be resumable and I would recommend users only download
with a Wifi connection.

What sort of data is this?! It would have to be incredible to justify that
size to most users, I think with a 3 hour install you have lost 99% of the
user base without even knowing if the app is any good.

Gav





--~--~---------~--~----~------------~-------~--~----~


Sponsored Links


Other Threads

1. Location ,coordinates Problem

Hi,
I'm working with android.Location with a simulator of coordinates that
sends them to the emulator:

import java.io.IOException;
import java.io.PrintWriter;
import java.net.Socket;
import java.net.UnknownHostException;
import java.util.Random;
import java.io.*;
import java.util.*;


public class MovementSimulator {

        private static final String hostname = "localhost";             // 
Hostname or
IPAddress of the host where the emulator is running
        private static final int port = 5554;                                   
// Android's console port

        private static final double initialLatitude = 11;               // 
Initial
Latitude
        private static final double initialLongitude = 11.1;    // Initial
Longitude

        private static final int millisecondsUpdate = 1000;             // 
Milliseconds
to wait between two consecutive fixes

        public static void main(String[] args) {
                try {
                        System.out.println("[+] GPS Movement Simulator 
Started.");
                        Socket link = new Socket(hostname,port);
                        PrintWriter out = new 
PrintWriter(link.getOutputStream());

                        System.out.println("[+] Connected to Android's 
emulator.\n");

                        while (true) {
                                latitude += generator.nextGaussian();
                                longitude += generator.nexGaussian();

                                System.out.println("[*] Sending fix: 
"+latitude+" "+longitude);
                                out.println("geo fix "+latitude+" "+longitude);
                                out.flush();

                                Thread.sleep(millisecondsUpdate);
                        }

                } catch (UnknownHostException e) {
                        e.printStackTrace();
                } catch (IOException e) {
                        e.printStackTrace();
                } catch (InterruptedException e) {
                        e.printStackTrace();
                }

        }

}


but when the emulator receives the coordinates they are not the same
that the simulator sends, they are only similar.It si a problem of the
emulator?

An example I send:
12.002000666666667 44.007333599999995
12.001069999999999 44.00733346666666
12.000299999999999 44.007333599999995
12.000030999999999 44.00733373333334
12.000010099999999 44.00733400000001
12.000000133333334 44.00733400000001
12.000000266666668 44.00733400000001
12.000000500000002 44.00733400000001
12.000001066666667 44.00733373333334
12.000001666666667 44.008333599999995
12.000000666666667 44.00933346666666
12.000000490000002 44.01033346666666
12.000000266666668 44.01083346666666
12.000000133333334 44.012033346666666
12.000000150333334 44.012033346666666
12.001999999999999 44.00733333333333
11.985169433333333 44.00733333333333
11.985169383333334 44.00733333333333
11.985169383333334 44.00733346666666
11.985169383333334 44.007333599999995
11.985169433333333 44.007333599999995
12.002000133333334 44.007333599999995
12.001999999999999 44.00733346666666
12.002000666666667 44.00733346666666
12.002001 44.00733346666666
12.002001416666667 44.007333599999995
12.00200165 44.00733366666667
12.002001833333335 44.00733391666666
12.002001833333335 44.007334166666666

and the emulator receives(reads from right to left):

44.007334549999996 12.002000333333335***
44.007334549999996 12.002000166666669***
44.007334549999996 12.00200005***
44.007334549999996 12.001999999999999***
44.007334549999996 12.001999999999999***
44.007334549999996 12.001999999999999***
44.007334549999996 12.001999999999999***
44.007334549999996 12.001999999999999***
44.007334549999996 12.001999999999999***
44.007334716666676 12.001999999999999***
44.007334883333336 12.001999999999999***
44.00733505 12.001999999999999***
44.00733533333334 12.001999999999999***
44.00733533333334 12.001999999999999***
44.007334549999996 12.002000316666665***
44.007334549999996 11.985166966666668***
44.007334549999996 11.985166966666668***
44.007334549999996 11.985166966666668***
44.007334549999996 11.985166966666668***
44.007334549999996 11.985166966666668***
44.007334549999996 12.002000333333335***
44.007334549999996 12.002000316666665***
44.007334549999996 12.002000333333335***
44.007334549999996 12.002000333333335***
44.007334549999996 12.002000333333335***
44.007334549999996 12.002000333333335***
44.007334549999996 12.002000333333335***
44.007334549999996 12.002000333333335***

I'm trying to use also  the Emulator Control(from Eclipse) but when I
send a coordinates to the device nothing happend..
Any Idea?
thanks
--~--~---------~--~----~------------~-------~--~----~

2. JetBoy Sample Question

Hi there,

I have a question regarding the Jeyboy game that comes with the SDK. I
noticed the game runs in Landscape mode which is cool. I looked at the
code but I can;t find the command that forced the game to be played in
landscape mode.
I wrote a simple code that draws a image but I want it to be always on
Landscape mode.How can I do it?

Hope someone helps me out here.

Thanks,


--~--~---------~--~----~------------~-------~--~----~

3. how to register in the opencore framework own file container recognizer

4. Several instance of AsynkTask

5. Crashing compasse

6. onTouch()

7. how to access several xml views in my activity?