Hi Jack,
I'm expecting less than 10 records in the resulting set.
The BlockUnit table contains 337,253 records; the InteractionParts table
contains 279,953 records.
It takes currently 8.3 seconds to execute the query as I have it.
Erh, this is embarassing but I'm going to need some help re-writ
Oh, sorry I forgot to mention this. It's a MySQL database.
- Original Message -
From: "Micah Gersten" <[EMAIL PROTECTED]>
To: "YVES SUCAET" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, September 25, 2008 7:55 PM
Subject: Re: [PHP-DB] query optimization
Other question is, what DB is this
Could you guys share your development setup, like what kinds of software
(IDE's/Editors) you are using for developing php scripts?
It might sound silly but I am just curios, as I just got started in php
programming en i have firefox + kate/bluefish + LAMP built with gentoo.
Im mostly thinking tha
On Fri, Sep 26, 2008 at 11:22 AM, muhsin <[EMAIL PROTECTED]> wrote:
> Could you guys share your development setup, like what kinds of software
> (IDE's/Editors) you are using for developing php scripts?
> It might sound silly but I am just curios, as I just got started in php
> programming en i ha
On Sep 26, 2008, at 11:22 AM, muhsin wrote:
Could you guys share your development setup, like what kinds of
software (IDE's/Editors) you are using for developing php scripts?
It might sound silly but I am just curios, as I just got started in
php programming en i have firefox + kate/bluefish
MySQL queries use 1 index per table, so to speed the query, we need to
know what indices you have for the 2 tables.
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
Yves Sucaet wrote:
> Oh, sorry I forgot to mention this. It's a MySQL database.
>
> - Origi
Jason Pruim wrote:
On Sep 26, 2008, at 11:22 AM, muhsin wrote:
Could you guys share your development setup, like what kinds of
software (IDE's/Editors) you are using for developing php scripts?
It might sound silly but I am just curios, as I just got started in
php programming en i have firef
On Sep 26, 2008, at 1:17 PM, muhsin wrote:
Jason Pruim wrote:
On Sep 26, 2008, at 11:22 AM, muhsin wrote:
Could you guys share your development setup, like what kinds of
software (IDE's/Editors) you are using for developing php scripts?
It might sound silly but I am just curios, as I just
Though I do not profess to be a MySQL expert, INSTERT will definitely mess
things up for you as will the s at the end of values, given that you are
inserting multiple values :)
Richard.
- Original Message -
From: Jason Pruim <[EMAIL PROTECTED]>
Date: Friday, September 26, 2008 6:39 pm
S
Hi Micah,
I'm learning here. Great! :-)
How can I look this up? I'm pretty sure multiple fields are indexed. So
should I specify explicitely which indices should be used? What fields do
you think should be indexed? I do have control over the database and can
create additional indices.
Can y
MySQL < 5.0 can only use 1 index per table.
MySQL >= 5.0 can use more than one via an index merge.
http://dev.mysql.com/doc/refman/5.0/en/index-merge-optimization.html
On Sat, Sep 27, 2008 at 2:47 AM, Micah Gersten <[EMAIL PROTECTED]> wrote:
> MySQL queries use 1 index per table, so to speed the
Fergus Gibson wrote:
On Fri, Sep 26, 2008 at 10:17 AM, muhsin <[EMAIL PROTECTED]> wrote:
Im stuck with this on my early scripts that im experimenting.These are the
echo of the SQL part:
INSERT INTO movietype (movietype_id, movietype_label) VALUE (1, 'Sci Fi'),
(2, 'Drama'), (3, 'Adventure'),
12 matches
Mail list logo
