Ruslan,
>
> Size of this db ?
>
This database is about 8 MB. If all the records were
there, it would be around 130 MB. The size of the
database doesn't seem to make a difference. I tested
using this one and still experience the slow loading.
> This is only database?
>
> So you do on this db which query ?
I'm using the "SQLSelect" function with the query
"SELECT data FROM Stories WHERE StoryNumber=1". And,
once again, I am using a server-side cursor.
Once I get the cursor, I use the "Cursor_GetFieldRef"
function to get a reference to the "data" field.
put Valentina("Cursor_GetFieldRef", tRecID, "data")
into tFldRef
Then I use "Binary_ReadData" like this:
get Valentina("Binary_ReadData", tFldRef,
"gStackContents", Valentina("BLOB_GetDataSize",
tFldRef))
This all works fine except that it is really slow with
a server database.
>
> How many records is found ?
Just one.
>
> Have you try query this db under Vserver from
> Vstudio?
> It can specify client or server side cursor to use.
>
Yes, and it's slow there too.
> You work with VXCMD or other ?
>
Yes, VXCMD.
> Platform of server? MAC ?
> Of client ?
Platform of server is Mac, and platform of clients are
OS X, OS 9, and all versions of Windows. The client
platform doesn't make a difference.
I'm confident that if you'll take this database and
run a query on it, you'll see what I mean. Sometimes
it takes as much as 10 or 15 seconds, when it should
only take 2 or 3 at the most.
Thanks,
=====
Chris Sheffield
Read Naturally
www.readnaturally.com
__________________________________
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
http://mobile.yahoo.com/maildemo
_______________________________________________
Valentina mailing list
Valentina .at. lists .D.O.T macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2004 Chris Sheffield |
