dschuchman
New Member
is it possible to clear a progress database cache?
have a query that runs slow the first time and then fast afterwards since the records are all cached.
trying to determine why the initial query is slow (doing a FOR EACH thru 300 or so records and some other FINDs in the loop)
it takes around 30 seconds first time and then less than a second after that.
is there some proutil command i can give my database to clear the cache?
tried just doing a for each thru a large table and having it run for an hour and then doing my query, but that' s kinda a painfully slow way to debug my first query.
running my db in multiuser/server mode in unix.
any help would be appreciated. thanks, Dan
have a query that runs slow the first time and then fast afterwards since the records are all cached.
trying to determine why the initial query is slow (doing a FOR EACH thru 300 or so records and some other FINDs in the loop)
it takes around 30 seconds first time and then less than a second after that.
is there some proutil command i can give my database to clear the cache?
tried just doing a for each thru a large table and having it run for an hour and then doing my query, but that' s kinda a painfully slow way to debug my first query.
running my db in multiuser/server mode in unix.
any help would be appreciated. thanks, Dan