On 8 Jan 2018, at 8:42pm, Shane Dev <devshan...@gmail.com> wrote: > Do you mean it would be more efficient to generate entries such as these > (with randomly chosen integers and running numbers) in the application and > then committing them to the database with sqlite3_exec or similar?
There’s the question of understanding and debugging the code. It’s possible to do strange and complicated things entirely in SQLite. Especially with RCTEs and triggers. But when you see things like num+1, cast(round(abs(random())/9223372036854775808) as int) from you’ve probably looking at sanity in the rear view mirror. Suppose someone has to read your code and figure out what it’s meant to do. If you expect your code to be read by others, the amount of documentation you'll have to write takes longer than writing the software properly. > For a large number of entries, I assumed there would be greater overhead in > preparing and binding the values than both generating and storing them with > a single RCTE. SQLite is just software written in C. There’s no reason to believe it’ll be any more efficiently than your own C code. Even your respect for the SQLite development team shouldn’t outweigh the advantage of working with code you write yourself. How low do you need the overhead to be ? Have you tried a simple solution and found it takes an unacceptable time ? Did you get complaints from your customers ? You can spend two days writing complicated code which shaves 45 milliseconds off your execution time. Code which is difficult to debug and too complicated for other people to understand. Or you could spend those two days adding a useful function to your program. Or lying on a beach. Simon. _______________________________________________ sqlite-users mailing list firstname.lastname@example.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users