Re: [sqlite] Equal distribution from random rows

On Wed, 30 May 2007 15:18:18 -0400, John Elrick wrote > After running a simple test, I confirmed a suspicion. VACUUM > doesn't reorder the ROWIDs, so you still have breaks. My tests show otherwise: [alex]# cat 01_vacuum_table_test.sql CREATE TABLE foo ( string varchar(1) not null ); INSERT I

[sqlite] Equal distribution from random rows

Hello, I'm working on a project that requires random images to be chosen from a live database for a dynamic homepage. I found this link from Dr. Hipp that details a very fast approach to selecting random rows: http://www.mail-archive.com/sqlite-users@sqlite.org/msg14652.html Unfortunately,