I'm new in using SQLite and have some questions before I start implementing the SQL lite in a project.
Is there a way to insert a row of data into a table without having to convert the data to SQL ? I need to store 1024 point into a row, but converting it first to text and then let the database store it as binairy is a bit to mutch overhead.... Can we create a object with data and store that into the table ? Wat kind of speed can we expect of the database ? At some error situation we need to insert over 500.000 records a second. I know this is a speed no database will handle, so we have a very large buffer in the appliaction, but i need to be sure we can handle this in data in a reasonable time. I read some thing about 50.000 inserts a second (with ease) in the FAQ with START and COMMIT. Any experience ? Is there a difference in speed between running the database on linux or windows ? And what about stroing the database onto a Solid state disk or on a Raid 6 array normal HD.... Best regards, Mark Flipphi _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
