Re: [PERFORM] Query 200x slower on server [PART 2]

NbForYou wrote: See Query 200x slower on server [PART 1] before reading any further Cant' find it. Sorry. QUERY PLAN ON MY HOME SERVER [snip] Total runtime: 125.432 ms This means that the Query is 200 times slower on the webhost! How can I resolve this? First - what is different

[PERFORM] Query 200x slower on server [PART 2]

See Query 200x slower on server [PART 1] before reading any further QUERY PLAN ON MY HOME SERVER Sort (cost=1516.55..1516.59 rows=15 width=640) (actual time=123.008..123.435 rows=1103 loops=1) Sort Key: aanmaakdatum - Subquery Scan producttabel (cost=1515.39..1516.26 rows=15 width=640)