The moose likes Performance and the fly likes Sybase ASA database is getting slow . Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Performance
Bookmark "Sybase ASA database is getting slow ." Watch "Sybase ASA database is getting slow ." New topic

Sybase ASA database is getting slow .

ashu sindhu

Joined: Sep 16, 2001
Posts: 4
Hi Guys ,
My application is basically to move data from one database to another ( like from DB2 to Oracle or DB2 to ASA ).
When I run it for moving data from DB2/Oracle to ASA it takes long time .
The observation is :
Time take to move data from DB2 to Oracle = 10 min .
Time taken to move same data from DB2 to ASA = 45 min .
One thing I would like to mention is that It involves lakhs of records . The ASA database is initially fast but as it proceeds , the time taken to insert increase .
Can anyone tell me if there is any limitation on the number of records the database can hold with good performance .
I have already tried -c and -gp option for ASA database , but it didnt helped .
Ashu Sindhu
I agree. Here's the link:
subject: Sybase ASA database is getting slow .
It's not a secret anymore!