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 .D.O.T kherson.ua>
wrote:
> On 6/30/04 7:57 PM, "Chris Sheffield"
> <cm_sheffield@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 .D.O.T 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@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
_______________________________________________
Valentina mailing list
Valentina .AT. lists .D.O.T macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2004 Chris Sheffield |
