Three Questions...

[Ruslan Zasukhin]

on 11/25/03 1:06 AM, Ken Ray at kray at sonsothunder.com wrote:

> Ruslan,
> 
> I have three questions that came up during development that I hope you
> can shed some light on. (BTW: Feel free to copy your answer to the list
> if you wish)
> 
> Question #1:
> 
> Our current software uses two databases - one for main data storage
> ("iedb") and one as a set of zip codes for lookup ("iezips").
> Additionally, when the user logs in, we access "master.vdb" to confirm
> whether they are actually appropriate users of the system. In any event,
> looking at the Terminal log shows that we have three connections (one
> for each DB) for each user during our program initialization. Does this
> mean that we need to use 3 connections per user? We had always thought
> it was a kind of "one connection per user" that we would be selling
> until we saw the terminal output.

> If this is the case, can I assume that as soon as the connection to a
> database is closed that the connection can be reused? For example, if we
> used the "master.vdb" connection very briefly at login and closed that
> connection, the user would only have two active connections against the
> total connections that were licensed for the server, right?

1) yes, you can reuse connection after close.


2) Hmm, I wonder that masterdb also cause additional connection!!!
Igor is this true? 
Why?


3) yes, each database opened by a user is considered as connection.
You think this is wrong?

Inside of each db-connection you can make any number of cursors.

Hmm, may be this is really is wrong.

I need check if Other DBMS allow inside of one connection work with few dbs
on sever...


Problem is that in our way, we get very easy way to modify local db sources
to remote db.

I know that other do something as next.
May be there is sense for us redo it also.
Or add and support both ways via overloaded constructors...

    conn = new Connection( host, user, passw )

    db1 = new Vdatabase( conn )
    db2 = new Vdatabase( conn )

    db1.Open("aaa")
    db2.Open("bbb")


    db1.Close()
    db2.Close()

    conn = nil


I.e. Make Connection as separate abstraction...


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