Novice questions

[Ruslan Zasukhin]

On 9/23/05 6:22 PM, "Francois H" <francois.hebert at gmail.com> wrote:

Hi Francois, 
 
> Small question.
>  
> I show 10000 user name in a Datagrid. (from Table1)
> 
> When the user click in a user, I show user sub-infos(multiple field (where
> userID =...)from Table2)
> 
> What are the fast way to do that?
> 
> - Keep the DB open for all the session to save opening time

In fact usually people keep db open while apps runs.

> - Keep a recorset always in memory (from table2) and just make "filter" on it?

All records of T2?   --  NO

> - Can I close a DB and keep a recorset in memory?

Only if you convert them into list of Lingo

> - Valentina.shutdown are recommanded after each Db manipulation, or only at
> Projector closing?

On project closing!

> Many "novice question"... but it's important to start in the good way!
>  
> Really nice xtra.

Thank you.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]