[EMAIL PROTECTED] wrote:
Now I turn hyperthreading off and readjust the conf . I found the bulb query
that was :
update one flag of the table [8 million records which I think not too much]
.When I turned this query off everything went fine.
I don't know whether update the data is much slower than i
Has anyone seen a benchmark on the speed difference between:
SELECT * FROM item WHERE id=123;
and
SELECT * FROM vendor WHERE id=515;
versus:
SELECT * FROM item LEFT JOIN vendor ON item.vendor_id=vendor.id WHERE
item.id=123;
I only have a laptop here so I can't really benchmark properly.
I'm h
Amrit,
can you post
explain
so we can see what it does ?
Dave
[EMAIL PROTECTED] wrote:
Today is the first official day of this weeks and the system run
better in serveral points but there are still some points that need to
be corrected. Some queries or some tables are very
> > Today is the first official day of this weeks and the system run
> > better in serveral points but there are still some points that need to
> > be corrected. Some queries or some tables are very slow. I think the
> > queries inside the programe need to be rewrite.
> > Now I put the sort mem to
Hi,
On Tue, Jan 04, 2005 at 10:06:18AM -0800, Josh Berkus wrote:
> > are there any plans for rewriting queries to preexisting materialized
> > views? I mean, rewrite a query (within the optimizer) to use a
> > materialized view instead of the originating table?
>
> Automatically, and by default,