[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=64

Re: [PERFORM] database model tshirt sizes

: 'l', quantity: 1 productid: 442, versionid: 2, color: 'yellow', size: 's', quantity: 4 productid: 442, versionid: 2, color: 'red', size: 'xl', quantity: 9 productid: 442, versionid: 2, color: 'blue', size: 's', quantity: 0 product

[PERFORM] database model tshirt sizes

Hello,   Does anybody know how to build a database model to include sizes for rings, tshirts, etc?     the current database is built like:   table product =   productid int8 PK productname charvar(255) quantity int4     what i want now is that WHEN (not all products have multiple sizes

Re: [PERFORM] Process Time X200

however that this information is accurate... I thank everybody who have responded so far. Great feedback! - Original Message - From: "Richard Huxton" To: "NbForYou" <[EMAIL PROTECTED]> Cc: "Michael Fuhr" <[EMAIL PROTECTED]>; Sent: Friday, Mar

Re: [PERFORM] Process Time X200

. And running a webhosting service is a commercial use. thanks for replying and going through the effort of creating the database and populating it. Nick - Original Message - From: "Michael Fuhr" <[EMAIL PROTECTED]> To: "NbForYou" <[EMAIL PROTECTED]> C

[PERFORM] Process Time X200

Hello,   I could need some help.    I have a Postgresql database When i do a query on my homeserver the result is given back fast but when i do the same query on my webhost server the query is useless because of the processtime (200 times slower  (56366.20 / 281.000 = 200.59) ). My Pc is ju