Hi I write tou you because, i have a problem with table updates, i fixed a problem of connection db
Cannot get a connection, pool error Timeout waiting for idle object
with increasing the number of connections from 8 to 20
then i still have problems of connection db, then Greg suggest this
(Tue Feb 05, 2013 2:05 pm
Joined: Fri Mar 16, 2012 1:00 pm
Location: Sacramento, CA
Re: Database Faults after a few days
I would suggest looking at the status page and selecting database. You can enable the live values and see what is taking a long time to run. Additionally, you can go to configure and store and forward and look at the quarantine control tab to see what is being quarantined. This will also give you some additional information that can give you an idea as to why they queries are being quarantined. If you have already increased to 20 then you should be looking into my suggestions above to get to the root cause to the issue.
As a side note, its usually best to start a new thread with your question.)
and I did what he said, after done it, i didn’t have again problem with connection db.
but I saw that the tables udpdates doesn’t update fast, it takes too much time. And i need to make it faster again.
the ignition system works in a server with 6 GB of memory.
I don’t understand why the update isn’t working normal.
I tried differente polling modes, and still doesn’t update in a normal time, it take too long.
Please help me