Terracotta Discussion Forums (LEGACY READ-ONLY ARCHIVE)   Search   Recent Topics     Member Listing    Back to home page  Register /  Login  [Expert]

Messages posted by: sesker   Profile for sesker -> Messages posted by sesker [3] Author Message Quartz -> Retrieving all job incredibly slow -> Go to message What tables do you suggest to index, and on what columns? Quartz -> Retrieving all job incredibly slow -> Go to message No indexes... I used the standard DDL that was included with the product, and that had no indexes.. I will look into indexing the tables, but with 60-100 jobs, I wouldn't think that would make that big of difference... Quartz -> Retrieving all job incredibly slow -> Go to message We have an application that has around 60-70 quartz jobs defined and executing, many concurrently. The problem is we have an administration ui for the quartz job and when we attempt to retrieve all the jobs, via the prescribed way: 1. get all job groups names 2. get job names for group 3. get all job details for each name in group The system hangs for many seconds while fetching the information. I have looked at the database logs, etc, and it looks like the is contention while quartz is updating job information and other things. Has anyone run into this? Is there a better method for getting all the jobs and their job details? Profile for sesker -> Messages posted by sesker [3] Go to:  Select a forum BigMemory Ehcache General Quartz BigMemory + Hadoop Terracotta for Web Sessions Terracotta Platform Terracotta Licensing Terracotta 中文社区 Terracotta for Spring

Powered by JForum 2.1.7 © JForum Team