#1  
Old 14th December 2010, 03:26 PM
Leslie Leslie is offline
Senior Member
 
Join Date: Dec 2010
Posts: 291
Default Blob update

I still lack the experience with NexusDB under heavier load, but its design suggests that updates needs more attention. Where can I find info about the best pratices of updating a blob field? I need to update possibly very large blob fields over the internet.

It seems the fileblobs are the way to go, but I am still in the dark what to expect performance wise if the updates are done through db updates. So some link/info would be nice about fileblobs. Main main interest is how can they be transfered from one server to an other?
  #2  
Old 14th December 2010, 03:33 PM
Leslie Leslie is offline
Senior Member
 
Join Date: Dec 2010
Posts: 291
Default

Main main interest --> My main interest
  #3  
Old 15th December 2010, 09:06 PM
Keith Johnson[NDX]
 
Posts: n/a
Default Re: Blob update

On 14/12/2010 04:26, Leslie wrote:
> I still lack the experience with NexusDB under heavier load, but its
> design suggests that updates needs more attention. Where can I find info
> about the best pratices of updating a blob field? I need to update
> possibly very large blob fields over the internet.
>
> It seems the fileblobs are the way to go, but I am still in the dark
> what to expect performance wise if the updates are done through db
> updates. So some link/info would be nice about fileblobs. Main main
> interest is how can they be transfered from one server to an other?



I don't think FileBlobs is needed.
To copy blobs in it's simplest form you can just do ->

DestTableField.AsVariant := SourceTableField.AsVariant

But if your moving large blobs, it might make sense to use
CreateBlobStream so that you can maybe show a progress bar to the end user.

Delphi's help has some examples on using CreateBlobStream, Delphi7 Help
shows using CopyFrom, instead of this you would use ReadBuffer /
WriteBufffer so that you could update a progress bar.
  #4  
Old 16th December 2010, 12:24 AM
Leslie Leslie is offline
Senior Member
 
Join Date: Dec 2010
Posts: 291
Default

Progress feedback is a must, so it seems it has to be BlobStream. Hope it works with fielblobs. The reason I would like to use them if possible, because it allows easy and fast incremental backup on none changing blob data.

Thank you for your responce.
  #5  
Old 16th December 2010, 12:40 AM
Thorsten Engler [NDA]
 
Posts: n/a
Default Re: Blob update

Leslie wrote:

>
> Progress feedback is a must, so it seems it has to be BlobStream. Hope
> it works with fielblobs. The reason I would like to use them if
> possible, because it allows easy and fast incremental backup on none
> changing blob data.
>
> Thank you for your responce.


Just keep in mind that fileblobs are read-only.
  #6  
Old 16th December 2010, 12:58 AM
Leslie Leslie is offline
Senior Member
 
Join Date: Dec 2010
Posts: 291
Default

I will.


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
BLOB Compression, saving files to a BLOB Scott Martin nexusdb.public.support 20 9th March 2007 10:04 PM
Re: BLOB Compression, saving files to a BLOB Emmanuel Barache nexusdb.public.support 1 1st March 2007 11:29 AM
Exception: General BLOB error. [$2E78/11896] when displaying memo blob field: Tekst Chiwa nexusdb.public.discussions 4 1st September 2006 11:48 AM
Exception: General BLOB error. [$2E78/11896] when displaying memo blob field: Tekst Chiwa nexusdb.public.support 5 1st September 2006 11:48 AM
Notice: RC5 potential blob problem, blob > 512Kb Eivind Bakkestuen [NDD] nexusdb.public.support 5 27th August 2003 02:52 PM


All times are GMT +11. The time now is 07:30 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.