sqlite administrator

domi.papin · Post by **domi.papin** » 11.10.2006, 10:21

Hello,

I've used sql administrator to connect to a sqlite3 database. my database contains a table image of around 3000 records of 4 fields. the latest field is a binary blob containing the image.

If I display all the image table data, it takes a long 30 seconds to show up. How do you explain this ?

Dominique

zippo · Post by **zippo** » 11.10.2006, 23:09

what do the blobs contain? Is there any average size estimation of blobs?
Also - watch the memory usage during table opening. Is there a possibility that the PC begins to swap (hint: massive disk LED blinking..

) beacuse no more RAM available? If yes, then the tables are too big.

And of course - report here...

domi.papin · Post by **domi.papin** » 12.10.2006, 10:09

the blobs are filled with jpeg and png files. They are about 200ko average size.

SQLite Administrator doesn't swap as I have 1Go RAM and it allocates a max 11Mo
during table opening. But it hits a lot the hard disk.

By the way, I use SQLIte admin 0.8.2.6beta. Maybe there is a more recent exe.
Another hint is that the whole database file weights 625Mo.

Hope this helps......

Orbmu2k · Post by **Orbmu2k** » 07.11.2006, 16:18

Where do you lookp the Table Data? At "Edit Data" Tab ... this uses a TZTable Object wich fetches all Data i mean. Try to use a simple query with and without selecting the blobfield. On Simple Querys you also can edit in the Result Grid.