Home > Archive > SQL Anywhere database > August 2005 > Performance Problem with SQLAny DesktopRuntime 5.5









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]

 

Author Performance Problem with SQLAny DesktopRuntime 5.5
Thomas

2005-08-24, 3:23 am

System:
- WinXP SP2
- about 600MB database file
- SQLAny DesktopRuntime 5.5. Engine
- connection: ODBC
Problem: specific write operations with BLOBs are extremly
slow, all other operations (queries) behave normal; On other
ASA servers (e.g. 8.0) I can't reproduce this problem
Question: Are any limitations or bugs of the RtDsk server
known?

Thanks
Matthew Chestnut

2005-08-24, 8:24 pm

The runtime engine does not use a transaction log, thus has to
checkpoint more frequently. This hurts performance.

On 24 Aug 2005 00:30:18 -0700, Thomas wrote:

>System:
>- WinXP SP2
>- about 600MB database file
>- SQLAny DesktopRuntime 5.5. Engine
>- connection: ODBC
>Problem: specific write operations with BLOBs are extremly
>slow, all other operations (queries) behave normal; On other
>ASA servers (e.g. 8.0) I can't reproduce this problem
>Question: Are any limitations or bugs of the RtDsk server
>known?
>
>Thanks
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com