On 6/30/04 7:57 PM, "Chris Sheffield" <cm_sheffield AT yahoo .DO.T 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@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 .DO.T macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2004 Ruslan Zasukhin |
