Use sqlite prepare and bind. Mark Flipphi wrote: > 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 >
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users