[EMAIL PROTECTED] wrote: > > I'm in the process of architecting the software for an embedded Linux system > that functions as a remote and local user interface to a control system. > There > will be a lot of analog (fast) data arriving via SPI bus and I'm thinking of > using SQLite to store this data in a well organized and easy to access > manner. > > My main concern is performance. Has anyone had any similar application > experience they could comment on? I want to be able to insert data arriving > on the SPI bus and then query the data to update a GUI at a very high rate > (less than 250Ms). This is not real time so 250Ms is desirable but does not > have to be guaranteed. > > Any thoughts or experience would be appreciated... >
You arn't clear about your update rate, or the amount of data you need to extract for each GUI update. You also haven't said where you will be storing the database, in RAM, on a hard disk, or in flash. If the data is only updated every 250 ms, i.e. at a 4 Hz rate, it is not really very fast, and SQLite should have no problem keeping up even on an embedded processor. If the GUI has to display only the last value every 250 ms, then you should have no trouble. If you are trying to redraw a scrolling graph of the last 400 samples every 250 ms you may have issues to be concerned about. Dennis Cote _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
