On 14 Feb 2012, at 7:01pm, Rob Richardson wrote: > The application is written in C#, and uses a .Net provider for SQLite. > > The code to insert tag data is very crude. I build an INSERT query as a > string, and then I call the database object's Execute() method. > > The average time to update a base is half a second.
Does this include Non-SQLite-related operations ? Does this include the time to open and close the database connection ? How is the computer accessing the database files: are they on the boot disk, or across a network or what ? If it's just the time to execute the execute, it's ridiculously long. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
