Excellent advice. If you can use FTP and the file system for large files it
is best to keep them out of the database.

InterBase (IMHO) isn't setup well to be administered as a container for many
large BLOB's. For one thing, it becomes impossible to have an efficient
backup routine on a daily basis. You have to eventually do your own roll
forward logs and maintain your own backup strategy. This just isn't
practical since this doesn't come out of the box.

Lester's advice here is worth pursuing.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <lester@...>
To: <IBObjects@egroups.com>
Sent: Wednesday, January 24, 2001 5:22 AM
Subject: Re: [IBO] Performance (as a result of blob inserts)


> We run a network of machines over Frame Relay. 48kBaud links to each
> remote site, but with up to a one second ping! ( Frame Relay Buffers
> data ).
>
> All the simple database stuff works well, but we use FTP and separate
> files in place of BLOB stuff, so that transfer is faster and then we
> keep local copies of regularly used stuff to remove unnecessary
> transfers. ( Pump is great for duplicating information from main server
> to remote ).
>
> BLOB's are certainly an area that could be speeded up, but the real
> question is are they the best way of handling bulky data anyway?
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services
>
>
>