> SELECT
> books.book_name, bible.chapter, bible.verse, bible.versetext
> FROM asv_bible bible, book_bible books WHERE bible.book = books.id ORDER
BY
> random() LIMIT 1
> I was wondering if anyone could offer any help with lowering the time it
> takes to run?
I didn't see anything in your schema about an index on asv_bible.book
(book_bible.id is a primary key therefore an index is created implicitly).
Without an index on the book column, the join is going to take some time. I
would put an index on that and do a VACUUM ANALYZE. You should see a huge
speedup from that alone.
Greg
