Sybase & large blobs performance issue

Classic Servoy
1

Hi there,

we have some performance issues with Sybase regarding blobs.
I have a database server called files, with about 300 records, about 10 columns (varchars and integers) and 1 blob (media in Servoy)
In one record we have uploaded a 128MB zip file.

A simple query:

SELECT media FROM files WHERE filesid = '512' //this is the record with the 128MB zip file.

takes about 40-50 seconds, from Servoy or DBvis.
Is this normal??
Ofcourse the memory of dbsvr10.exe grows, but Java (does not matter if it is Servoy or Dbvis) memory goes trough the roof!!
before the query, Java start at about 110MB, and after the query ends about 550-600MB!!

Anyone else seen this? or have some reference material, with other DB vendors?

2

I did some searching ‘ianywhere large blob’ ;)

From that I did not find anything regarding time other than that it could have to do with the fact that your db files have to grow each time you insert a new blob.
One answer hinted towards a 8x decrease when the files are already big enough.

Maybe you should test this by removing a couple of records with blobs of that size and then add one/two again and see what that brings…

3

I did that allrady, put some more blobs in it, and removed some, even restarted Sybase, but the behaviour stays the same… :-(