[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    [sqlite] Question regarding Sqlite In-Memory DB Insert
From:       Nihar Dash <dashnihar () yahoo ! com>
Date:       2014-12-31 21:22:54
Message-ID: 1874920528.1658869.1420060974896.JavaMail.yahoo () jws10601g ! mail ! bf1 ! yahoo ! com
[Download RAW message or body]

HiI am using SQLite In-Memory DB for loading cache data into memory. I am using dotnet. The data I am inserting are .3 million. When I use the same number of records to insert in Console App it takes around 5 min. However If I host my app in IIS and Insert the same number of records It takes 60 minutes. No change in logic The DataSource is flat file. I am curious why the insert is so slow when hosted in IIS? I tried to search but did to get any answer.  Any help here is highly appreciated. thanksNihar
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[prev in list] [next in list] [prev in thread] [next in thread]