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
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,
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?
SELECT
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
:[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 calculation
, 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?
The
second is absolute killer on the db
bastien
that into 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: php-db@lists.php.net
Subject: RE: [PHP-DB] Slow Query
Date: Thu, 13 Jan 2005 00:30:34 -0800
Thank you
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
comma delimited string
me thinks its time for a new machine ;-)
Bastien
From: Wendell Frohwein [EMAIL PROTECTED]
To: 'Bastien Koert'
[EMAIL PROTECTED],[EMAIL PROTECTED]
CC: php-db@lists.php.net
Subject: RE: [PHP-DB] Slow Query
Date: Thu, 13 Jan 2005 13:21:33 -0800
Thank You Bastien.
My newest Vision that I had about
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
Wendell Frohwein wrote:
snip
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
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: php-db@lists.php.net
Subject: [PHP-DB] Slow Query
Date
12 matches
Mail list logo