A few questions

[Ruslan Zasukhin]

on 10/21/03 11:06, Ian Devaney at idevaney at mac.com wrote:

Hi Ian,

> Just a couple more questions...
> 
> As I said, I am currently developing the application using the local
> plugin/files etc. with a view to eventually running it as a vServer db.
> 
> Are there any other things I should be putting in my code no ready for
> the server version.

Ian, I think to really see what Vserver and require and what is it,
You need install it and play with its example1.
And you can compare it to example1 of LOCAL V4RB version.


> For example, should I somehow be testing for the connection to the db
> each time I access it?

No, you just open db.

> The other thing I am not completely sure about are the parameters used
> when creating a cursor.
> 
> When I create a cursor using a Select statement, I am doing nothing new:
> 
> cursor = mainDb.sqlSelect(s)
> 
> But  in the update/create methods I am now using I am passing
> parameters for locks etc. I don't fully "get" this and was wondering if
> these parameters should be different in the server version of the app.

No this params can be the same.

Okay, once again:

1) choice between ReadLock and ReadWrite I think is clear enough

2) choice between ForwardOnly and Random also is trivial.
    IF you know that you will do only on iteration forward then use
    Forward constant. This will make more effective work of server.

3) Server side cursor you choose when you need modify records,
        and/or if you have big selection.

    Client side -- read only records and for small selection.


-- 
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
-------------------------------------------------------------