Issue descriptionRange retrieval is painfully slow on topincs.com. Created: 2011-11-16 10:35:23, Robert Cerny Modified: 2011-11-16 16:47:02, Robert Cerny
Link,
No reifier
Comment
The topic proxies are fetched without subject identifier and locator so that saves some SQL statements, but range retrieval remains slow.
There is also a significant difference between the development machine (being faster!!!) than the production machine. Some SQL statements that take 0.02 s on dev take 0.15 s on prod while all other statements are compareable. Hmm.
Created: 2011-11-16 16:45:42, Robert Cerny Modified: 2011-11-16 21:07:42, Robert Cerny
Link,
No reifier
The delay seems to be caused a long NOT IN blacklist which makes sure that no non-domain topics are selectable, see [2603, this issue]. I confirmed this as well by appending %meta=1% to the URL where the .range request takes *0.5 seconds where it takes 7 seconds* without %meta=1%.
Created: 2011-11-16 20:29:41, Robert Cerny Modified: 2011-11-16 21:11:52, Robert Cerny
Link,
No reifier
Rejection comment
An MySQL server upgrade sped up the range retrieval from unusual 7 seconds to 1.5 seconds for the fairly complex enhancement form in this store.
Created: 2011-11-22 20:25:59, Robert Cerny Modified: 2011-11-22 20:25:59, Robert Cerny
Link,
No reifier
|
Reporting date2011-11-16 Created: 2011-11-16 10:35:22, Robert Cerny Modified: 2011-11-16 10:35:22, Robert Cerny
Link,
No reifier
Rejected by
Robert Cerny
Created: 2011-11-22 20:25:58, Robert Cerny Modified: 2011-11-22 20:25:58, Robert Cerny
Link,
No reifier
Caused by
Hide meta types during domain modeling (Change)
Created: 2011-11-16 21:07:41, Robert Cerny Modified: 2011-11-16 21:07:41, Robert Cerny
Link,
No reifier
Work sessions
Created: 2011-11-16 13:19:37, Robert Cerny Modified: 2011-11-16 13:19:37, Robert Cerny
Link,
No reifier
AffectsReported by
Robert Cerny
Created: 2011-11-16 10:35:23, Robert Cerny Modified: 2011-11-16 10:35:23, Robert Cerny
Link,
No reifier
Rejection date2011-11-22 Created: 2011-11-22 20:25:59, Robert Cerny Modified: 2011-11-22 20:25:59, Robert Cerny
Link,
No reifier
|