Here's the query:
---
SELECT * FROM bv_reviews r, bv_votes v
WHERE r.vote_id = v.vote_id
AND v.book_id = 113
---
bv_votes has around 7000 rows with
Vitaly Belman [EMAIL PROTECTED] writes:
What am I to do?
Reduce random_page_cost and/or increase effective_cache_size.
regards, tom lane
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL
Hi all,
I had a difficult time deciding which list to post
this to, so please forgive me if this list doesn't
perfectly match my questions. My decision will not
solely be based on performance, but it is the primary
concern. I would be very appreciative if you all
could comment on my test plan.
On Sat, 11 Sep 2004, Mark Cotner wrote:
There are no performance concerns with MySQL, but it would benefit
greatly from stored procedures, views, etc. It is a very large rolling
data warehouse that inserts about 4.5 million rows every 2 hours and
subsequently rolls this data off the back end