If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

How about some more pertinent information, like what type of database you're
using (SQL Server, Oracle, etc)? My suggestion would be to make a new table
(called 'BLOBData', or similar), that has only two fields; an identity
primary key, and the blob field. Remove the blob field from the customer
table, and replace it with a foreign key to the new BLOBData table. Getting
rid of the BLOBs should reduce page size and speed up any changes to the
table.

Re: Help: Optimize performance.

It really depends on what is in that blob field. Is the blob something like
a picture? If so then store the relative path to the directory where the
picture is located. If that is not possible then I would try to move the
blob data out of the table into a seperate table and create a one to one
relationship between the new blob table and the previous table. At least
then the updates to the heavily hit table would go quicker.

Re: Optimize performance.

One other idea. Is one of your indexes a clustered index. If so, you are
creating a lot of work for your server as clustered indexes physically
rearrange the data.

It sounds like you might have a small server (500MB directory, etc.) so you
might want to look at your hardware as a source of difficulty (# of
processors, memory, swap file allocation, spare disk space, network hardware
and connection types, etc.)

Re: Optimize performance.

recently a customer site has hit a problem.
> Performance relating to 1 table seems to have crawled.
> that table contains 1 blob field.
>
> currently inserts ,updates , deletes are slow like crap.
> recently (1wk ago) I did a database device migration from (messy all
>over
> the place database devices) into a single directory 500mb x 10 datadevices.
It may be that the original DBA deliberately put the devices on specific
disks for performance... its conventional to put log and data on different
discs, sometimes putting certain tables on diferent discs can help too -
is this SQL Server 6.5 or 7?