large BLOB data slow to load

[Chris Sheffield]

Ruslan,

Here is a link to a database you can download.  The
field in question is the "data" field in the Stories
table.  The BLOB data consists of a Revolution stack
file that has been gzip compressed and then saved to
the database.

http://www.readnaturally.com/Internal/RNSE/new%20rnse/Level8.0.vdb.sit


Thanks,
Chris

--- Ruslan Zasukhin <sunshine at public.kherson.ua>
wrote:
> On 6/30/04 7:57 PM, "Chris Sheffield"
> <cm_sheffield at yahoo.com> wrote:
> 
> Hi Chris,
>  
> >> Because of network of course.
> >> 
> >> What speed of your network?
> >> Is this local ethernet or dialup?
> >> 
> > 
> > My network is usually fast.  It's 10/100 ethernet.
> > Just a small network in my home office.  If I were
> to
> > copy the same data (it's just a file I'm saving in
> the
> > database) to another machine on my network, it
> only
> > takes about 2 seconds.  So it's not my network.
> > 
> >> 
> >> Aha.
> >> 
> >> How many records into cursor you get ?
> >> 
> >> Do you use client cursor?
> >> If yes then this means that ALL your records are
> >> read into RAM.
> >> This not happens when you work with local db.
> >> 
> >> To solve problem you need to use SERVER SIDE
> cursor.
> >> It will load into RAM only one record.
> >> 
> > 
> > I'm already doing this.  I'm using a server-side
> > cursor and only requesting one record from the
> > database.  It doesn't seem to make any difference.
> > 
> > I'm beginning to wonder if there's some kind of
> bug
> > with VServer that's causing this.  If there is
> anyone
> > out there who can confirm it, I would be grateful.
> 
> Well, it seems we did not see problems in our tests.
> Can you send some example proect?
> 
> > Just try loading a few MBs of BLOB data into a
> server
> > database and see what happens when you try to read
> > that data.  I think it's taking longer than it
> should.
> 
> Of course. 2 minutes, this is acceptable for dialup
> only.
> 
> > I'm going to try splitting out my BLOB data in a
> .blb
> > file and see if anything changes.
> 
> -- 
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need
> for speed ]
>
-------------------------------------------------------------
> e-mail: ruslan at paradigmasoft.com
> web: http://www.paradigmasoft.com
> 
> To subscribe to the Valentina mail list go to:
> http://lists.macserve.net/mailman/listinfo/valentina
>
-------------------------------------------------------------
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
> 

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com