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
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: php-db@lists.php.net
Sent: Thursday, September 25, 2008 7:55 PM
Subject: Re: [PHP-DB] query optimization
Other question is,
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
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 have
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 +
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.
-
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
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
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
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
10 matches
Mail list logo