> books.book_name, bible.chapter, bible.verse, bible.versetext
> FROM asv_bible bible, book_bible books WHERE bible.book = books.id ORDER
> 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.
In response to
pgsql-general by date
|Next:||From: Thomas Lockhart||Date: 2001-12-21 18:49:53|
|Subject: Re: How Many Years have Passed?|
|Previous:||From: Gregory Wood||Date: 2001-12-21 18:41:33|
|Subject: Re: Can't use subselect in check constraint|