problem with gift certificate

[Dashizna]

when i put that in it just takes forever and then goes to this screen back to the begining..

[Ajeh]

Sounds like you have a large number of customers and/or orders where your php is timing out based on the size of the SELECT statement ...

NOTE: this could be your server as I have 68,000 customers with 52,000 orders that takes 0.002 seconds ... the first time took 0.416 seconds ...

[Dashizna]

So then this is an issue with my hosting company? not Zen?

[Ajeh]

I would think so ...

How many customers and how many orders do you have?

[nagelkruid]

I would think so ...

How many customers and how many orders do you have?

Hello,

I know this threat is a bit old, but at the moment i have the exact same error message in zen and the same behaviour in php admin when i run the query from there.

I have approx 12.000 customers and a little less orders in my shop.

Do you please have a suggestion to make this query less intense on the MySQl?

[nagelkruid]

Hello,

I know this threat is a bit old, but at the moment i have the exact same error message in zen and the same behaviour in php admin when i run the query from there.

I have approx 12.000 customers and a little less orders in my shop.

Do you please have a suggestion to make this query less intense on the MySQl?

ps. on a similar server with same database it does run:
Toon Records 0 - 29 (1.794 totaal, Query duurde 2.7893 sec)
SQL-query:SELECT DISTINCT c.customers_email_address AS customers_email_address, c.customers_lastname AS customers_lastname, c.customers_firstname AS customers_firstname
FROM engendcustomers c
LEFT JOIN engendorders o ON c.customers_id = o.customers_id
WHERE o.date_purchased IS NULL
LIMIT 0 , 30
it says the query took 2.7893 sec but i have waited at least 2 minutes to view the output

are there perhaps indexes or views that i can use to speed this up?

[gilby]

Hello,

I know this threat is a bit old, but at the moment i have the exact same error message in zen and the same behaviour in php admin when i run the query from there.

I have approx 12.000 customers and a little less orders in my shop.

Do you please have a suggestion to make this query less intense on the MySQl?

I assume you are NOT using zen139 ?

Consult this thread for a possible solution

http://www.zen-cart.com/forum/showthread.php?t=101799

[Danielle]

I'm seeing this error on a 1.3.9h store with about 8200 customers and 6800 orders. Would this be a hosting issue?