|
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! |
|
|
| |||
|
| ||||