On Wed, Jul 23, 2008 at 4:48 AM, Chris <[EMAIL PROTECTED]> wrote:
> Steven Macintyre wrote:
> > Hi all,
> >
> > Below is the query we are getting a slow response on ... 2seconds ...
> > with 4 records we were hoping to get it much quicker.
> >
> > Can someone advise if i can optimise this?
> >
>
Steven Macintyre wrote:
> Hi all,
>
> Below is the query we are getting a slow response on ... 2seconds ...
> with 4 records we were hoping to get it much quicker.
>
> Can someone advise if i can optimise this?
>
> SELECT s.movie_id, m.movie_name, movie_shortname, image_name,
> image_extension,
Hi all,
Below is the query we are getting a slow response on ... 2seconds ...
with 4 records we were hoping to get it much quicker.
Can someone advise if i can optimise this?
SELECT s.movie_id, m.movie_name, movie_shortname, image_name,
image_extension, m.trailerAvail
FROM sessions AS s
LEFT JO
me thinks its time for a new machine ;-)
Bastien
From: "Wendell Frohwein" <[EMAIL PROTECTED]>
To: "'Bastien Koert'"
<[EMAIL PROTECTED]>,<[EMAIL PROTECTED]>
CC:
Subject: RE: [PHP-DB] Slow Query
Date: Thu, 13 Jan 2005 13:21:33 -0800
Thank You Bas
TED]
Cc: php-db@lists.php.net
Subject: RE: [PHP-DB] Slow Query
Hi Wendell,
What you've proposed is not a bad solution. There is some initial work
to
set up the stuff for the existing agents, but if you define a limit to
the
range that the agent works in, then you can take the result stuff it
into a
co
o the agent_zip_codes field...then
the realtime time query is a simple IN (zip1, zip2, zipN) statement and
should be faster
Bastien
From: "Wendell Frohwein" <[EMAIL PROTECTED]>
To: "'graeme'" <[EMAIL PROTECTED]>
CC:
Subject: RE: [PHP-DB] Slow Query
Date: Thu, 1
n Koert [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 12, 2005 6:12 PM
To: [EMAIL PROTECTED]; php-db@lists.php.net
Subject: RE: [PHP-DB] Slow Query
are there indeces on the tables columns? Also does your query use the IN
(zip1, zip2, zipN) format or or do you query for each zip individually?
ailto:[EMAIL PROTECTED]
Sent: Thursday, January 13, 2005 12:02 AM
To: Wendell Frohwein
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Slow Query
How many agents do you have?
If the number of agents is small then you could set up a temp table
which has a link to the agent, the client, and a calcul
How many agents do you have?
If the number of agents is small then you could set up a temp table
which has a link to the agent, the client, and a calculation of the
distance between the two. Then do your search on this temp table. Once
you have the answer you want delete the records for this cli
are there indeces on the tables columns? Also does your query use the IN
(zip1, zip2, zipN) format or or do you query for each zip individually? The
second is absolute killer on the db
bastien
From: "Wendell Frohwein" <[EMAIL PROTECTED]>
To:
Subject: [PHP-DB] Slow Query
Date:
Wendell Frohwein wrote:
So I rewrote my script to do the follow:
The client submits a property for an appraisal.
Based on the appraisal type and property zip code, It does a radius
search of 2 miles from the property zip. If no matches are found, it
does a 5 mile radius search. For every zip code
First of all I would like to thank anyone who lends a hand in this
matter. Here is what im working with. Redhat 9, PHP 5.0.2,
Apache/2.0.50, MySQL 4.1.8-standard Binary Installation for
pc-linux-i686, OpenSSL 0.9.7d, gcc version 3.2.2. PHP compiled with
mysql, and mysqli capability.
This is how t
12 matches
Mail list logo