btsfreak1

"Your sever is setup incorrectly. That should take milliseconds to return with a properly setup server with those specs. You records number is low for what I have worked with to be honest." Not true. Some queries can easily exceed 20 seconds (!!!) execution time with connections tables holding a couple of million entries (on a highly optimized multicore VPS for the SQL instance) (hint towards: select max(c.`date_add`) as last_visit from `ps_guest` g left join `ps_connections` c on c.id_guest = g.id_guest where g.`id_customer` = ? limit ? in the Customer class). That has nothing to do with server setup but with bad SQL. That might have changed in 1.6.1, though. I highly recommend anyone to disable stats module and truncate those tables (they wont be emptied when disabling the modules).

Any ideas? Otherwise I will post a bug.

Possible solution: Ideally, there should be a possibility to set specific unit prices together with the specific prices.

I searched a lot but was quite surprised to find no info on this. In Prestashop 1.6.1, the specifc prices do not have any influence on the unit prices which makes the whole specific price mechanism useless for unit price based items. Example: We have products with unit prices (e.g. bell peppers), combinations (yellow, green, red) AND specific prices for differnet customer groups (end customer, wholesellers) We want end customer to have prices yellow: $20/kg, red $25/kg and green $30/kg We want whole sellers to have prices yellow: $15/kg, red $20/kg and green $25/kg Now for the product price, this works fine when using combinations for the attributes (yellow, red, green) with fixed amount price increases for each combination (+$5). And we can set specific different fixed prices for our wholesale customer group (not ideal but it works) So far so good. Problem is, that we cannot set any alteration on the unit price for each customer group. The unit price will always stay the same as defined in the main price tab in product edit page in admin area, no matter what customer group views it. That basically means it is impossible to create different price rules for products with unit prices in prestashop which I would consider a bug.