Hello, 
       I am a sqlite user from asia. I use sqlite for more than a year , now 
the version i am using is 3.8.11.1.
       But recently I meet a problem about inserting data into table.It is too 
slow whit index.
       The first I create a table like this:
        CREATE TABLE mac_tb  (mac BIGINT PRIMARY KEY?
        If I insert into mac_tb with mac ordey by num desc or asc , then the 
speed is fast.
        If I insert the mac randomly, then the speed will grow slower whit the 
increasing of data. It become slower if the count of mac_tb
more than 2,000,000.
        But if i create another table without index, than the speed is so fast.
        I don't know why the performance difference is so great.

Reply via email to