Message: 7         
   Date: Thu, 19 May 2005 23:36:37 -0700 (PDT)
   From: soonhuat ong <[EMAIL PROTECTED]>
Subject: RE: Few Delphi + Interbase question

Sorry i'm just too new with Delphi + Interbase.
I have debug my program and you are right, it's
IBDatabase.Connect that 
took it so much time. But is that any way for me to
solve it ? Even 
though i use the TIBSQL still i need to open and close
the connection 
rite. If so, then again it'll slow down the system. Or
is there any other 
better way for me to do so ?
On by the way, i didnt opening my connection to my
database while 
launching the form.  


reply
You can leave your database connection open for the
whole time that your form is open.
Put Database.Close in your form close event.

For tables and queries just set active to true

like IbTable.active := true;
if it alread active then there will be no change 
else it will open.

FWIW I use Fib+ and it flies.
My FireBird applications running head to head against
Paradox aps run 2 - 3 time faster.

Both a running against a server.
I do not regret moving to c/s sql. I regret that I
still have to work with Paradox.

mick


Find local movie times and trailers on Yahoo! Movies.
http://au.movies.yahoo.com


-----------------------------------------------------
Home page: http://groups.yahoo.com/group/delphi-en/
To unsubscribe: [EMAIL PROTECTED] 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/delphi-en/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Reply via email to