Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in August and this forum will be retired.

Hello, I am using UltraliteJ database on android tablet. It synchronizes with MSSQL server via Mobilink(SQL Anywhere 12). One of the tables contains an image column(varbinary(max)). When there are a few images it works well, but after the users entered 200-300 images the database became 300MB and the whole device started to work slow and give errors after connecting to the database(the database is located on the sd card). I cannot even go to settings to see how much RAM the app uses, need to restart the tablet.

Other thing is that Mobilink on my server after that synchronization uses over 500-600MB RAM and does not release the memory, keeps increasing to 1GB..

Can you give an advice how to fix that behavior?

asked 21 Oct '13, 15:21

katalun4o's gravatar image

accept rate: 85%

edited 21 Oct '13, 15:34

It is difficult to say what is happening, given this information. Depending on the sizes of the images, the database size and slowness may be expected behaviour. UltraLite databases should be able to grow to 2 GB. The database cache size may be a factor with performance, although the cache is dynamically managed. You could experiment with the cache_size/cache_max_size connection parameters. I would recommend opening a support case if you are having insurmountable problems. In that context, the case can be given detailed analysis.

(22 Oct '13, 10:51) Andy Quick

Is FileTransfer available for android with mobilink? I think it will be better to download the images as files, not in the database. Can you give me an example for android file transfer?

permanent link

answered 22 Oct '13, 08:42

katalun4o's gravatar image

accept rate: 85%

This one is easily answered. Yes.

See DatabaseManager.createFileTransferAndroid(...).

Hopefully you can figure out the concepts from:

(22 Oct '13, 10:41) Andy Quick
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 21 Oct '13, 15:21

question was seen: 3,603 times

last updated: 22 Oct '13, 10:51