On 8 March 2012 14:20, Black, Michael (IS) <michael.bla...@ngc.com> wrote: > You don't say what language you are working in. IN C++ I would just declare > a "set" and put random row numbers in it until I had enough. Then use that > set to build the SQL. > > SQLite's random() doesn't have a seed function so you don't really get very > random numbers from run-to-run and have no good way of controlling it that I > can find in the docs. You want to use your language's random function if you > want anything close to real randomness.
http://www.sqlite.org/c3ref/randomness.html claims high-quality PRNG > > Hopefully your language has a similar data structure you can use. > > > Michael D. Black > > Senior Scientist > > Advanced Analytics Directorate > > Advanced GEOINT Solutions Operating Unit > > Northrop Grumman Information Systems > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
