A Slower Database

-=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- (c) WidthPadding Industries 1987 0\|48\|0 -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=-
Socoder -> Off Topic -> A Slower Database
Wed, 27 Jan 2016, 14:20
HoboBen	I have a (read-only/SELECT) database query that is fast on my computer but slow on another computer and I don't know whyyyyyy -=-=- blog \| work \| code \| more code
Wed, 27 Jan 2016, 14:20
Jayenkai	Could it just be as simple as that system being slower? Other possibilities, memory limit, different Database version, more going on, things like that..? -=-=- ''Load, Next List!''
Wed, 27 Jan 2016, 21:06
HoboBen	Huh. Huhhhhh. I use pgpool2 (a connection pooler used to speed up a system by keeping database connections open rather than closing and opening them repeatedly). I use it because on my development system opening a database connection is the single slowest thing compared to everything else by far. The difference between rendering a page in 5 milliseconds and 100 milliseconds. ... I tried turning it off on the production server. The page now loads instantly. instantly, instead of waiting five whole seconds for a page to load. I have no idea what is up with that, but the latest version of pgpool is apparently all sorts of fucked up. -=-=- blog \| work \| code \| more code
Thu, 28 Jan 2016, 04:13
cyangames	Have you tried any tools like the ones at gtmetrix.com to check on if anything else is clogging things up at all? -=-=- Web / Game Dev, occasionally finishes off coding games also!