Greetings!
I am working on updating an application that has been around for years,
originally written by someone who knew SQLite exists but had very little idea
of how to use it. The application monitors OPC information for 124 bases, with
7-10 tags per base. (Don't worry about what a base is.) Each base has a
separate SQLite database file associated with it. Every minute, I have to
write the latest tag value for each tag into the correct database. Here is the
create statement for the table into which I am writing data:
CREATE TABLE trend_data( tag_key integer, value integer, value_timestamp
datetime );
There is no primary key specified for this table.
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. Since I've got 124 bases,
it takes almost exactly a minute to update each one. But I would like the
entire update process, for all bases, to be repeated every minute. Therefore,
I'd like to get the update time per base down to at most a quarter second.
What would be the best way to speed this up?
Thanks very much!
RobR
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
