Have you run any profiling tools to see where your C program is taking up time?
What if the 8 seconds is not from sqlite? Also make sure you are using transactions. --- On Thu, 1/8/09, Pramoda M. A <[email protected]> wrote: > From: Pramoda M. A <[email protected]> > Subject: [sqlite] 50 inserts takeing 8 seconds > To: [email protected] > Cc: [email protected] > Date: Thursday, January 8, 2009, 4:15 AM > Hi all. > > > > My desktop system with taking 8 seconds to insert 100 rows > with only one > column... > > > > I am inserting using Ffor loop (C interface) > > > > Can anybody help me? > > > > > > > > With Regards, > > Pramoda.M.A > > KPIT Cummins Infosystems Limited | Bengaluru > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
