Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL AnyWhere 9.02 very slow

58 views
Skip to first unread message

thomastroxler

unread,
Oct 30, 2006, 10:52:32 AM10/30/06
to
I'm fighting with performance problems here. We have a
customer that uses an ERP-Software that's based on Sybase
SQL Anywhere 9.02. The database "weights" is about 5GB.

When searching large tables (> 1 mio. records) it takes a
long time until the resultset is available. We checked all
the indexes and I think thay are correct (all searched
values are in the index).

One problem may be that the ERP-software uses two CHAR(10)
fields for the primary key. But I cannot change this because
I'm not the autor of the software...

Any Ideas on how or where I can increase the performance of
the server?

Hardware doesn't seams to be the problem. The server is
running on 2-3% CPU usage and there is enough free memory.

The memorylimit of the database is set to 512MB. Increasing
this Value doesn't increase performance.

Any ideas?

Breck Carter [Team iAnywhere]

unread,
Oct 30, 2006, 12:49:39 PM10/30/06
to
If you are using build 3124 or later you can use the
LogExpensiveQueries feature to find the slow queries and capture their
graphical plans...
http://www.ianywhere.com/developer/sql_anywhere_developer_corner/logexpensivequeries_jasper.html

If you know what the problem queries are, you can run them in dbisql
and capture the graphical plan; see the same article for some tips.

Save the plans as .XML files and email them.

What is the value of optimization_goal? For most applications it
should be all-rows.

Breck

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck....@risingroad.com

Kornilov Alexey

unread,
Oct 31, 2006, 1:25:53 AM10/31/06
to
Very interesting, which ERP-software work on ASA?

<Thomas Troxler> сообщил/сообщила в новостях следующее:
news:45462dd0.6c5...@sybase.com...

Tom

unread,
Oct 31, 2006, 7:36:53 AM10/31/06
to
It's a swiss product called Profitex V6 (www.profitex.com).
It's a nice pice of software as long as you don't have to
much data in the tables...

> Very interesting, which ERP-software work on ASA?
>
> <Thomas Troxler>

ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ ×
ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:

Frank Ploessel

unread,
Nov 3, 2006, 1:27:17 PM11/3/06
to
Thomas,

We tracked some issues of slow performance down to wrong or corrupt data
distribution statistics misleading the optimizer. I would just try to run
CREATE STATISTICS <tablename>
for the tables involved in the statements, and see if this helps.

Frank

0 new messages