Re: [sqlite] randomness issues on windows

On Sat, Jun 25, 2011 at 11:20 PM, bob wrote: > i'm getting an issue relating to the use of the random() function in a > SQL query. > > i run 2 PHP scripts very quickly (less than 1 second apart). > > they use an SQL query like    SELECT * FROM table ORDER BY random() LIMIT 5; > > because the 2 scr

[sqlite] randomness issues on windows

i'm getting an issue relating to the use of the random() function in a SQL query. i run 2 PHP scripts very quickly (less than 1 second apart). they use an SQL query likeSELECT * FROM table ORDER BY random() LIMIT 5; because the 2 scripts run so close together (in time) i get the same valu