|
Home > Archive > SQL Anywhere database > June 2005 > Caching
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| I'm using ASA7 connecting with a software written in
powerbuilder,
in order to increase the perform, I know there are some
connection parameters that can enlarge the cache size, other
than this, how can I further manage the caching strategy?
Since when I have selected all the contents of a table, and
then do the same query again and again, the cache seems not
very stable to have the same high performance every time.
| |
| Chris Keating \(iAnywhere Solutions\) 2005-06-15, 9:23 am |
| While cache plays a role in performance, it may not be the reason why you
are getting inconsistent or poor performance.
What are the query plans telling you?
BTW In ASA 7, the cache size is dynamic (in the absence of any cache
settings that disable that feature)
<phil> wrote in message news:42aff99c.fae.1681692777@sybase.com...
> I'm using ASA7 connecting with a software written in
> powerbuilder,
> in order to increase the perform, I know there are some
> connection parameters that can enlarge the cache size, other
> than this, how can I further manage the caching strategy?
> Since when I have selected all the contents of a table, and
> then do the same query again and again, the cache seems not
> very stable to have the same high performance every time.
|
|
|
|
|