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.
Vahan Yoghoudjian <[EMAIL PROTECTED]> wrote:Try to comment the line if not myTable1.Active then myTable1.Open to check if the problem comes from the table really, there might be something else that is taking that much time, besides are you opening your connection to your database while launching the form or the application? -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of soonhuat ong Sent: Friday, May 20, 2005 5:12 AM To: [email protected] Subject: Re: [delphi-en] Few Delphi + Interbase question Hi, LOL English aint my main language sorry. As for your question, may i know what's the advantage of Firebird over Interbase ? For Question 1: I double click TIBDatabase component to open the Database Component Editor. Set everything correctly, then click at the test button. It shows "Connection successfully". Then i close the editor, and go back to my form and set the TIBTable Active property to true. But it dont allow me to do this and prompt out with this error message : "Dynamic SQL error SQL error code = -901 features is not supported" Any idea what's wrong with that?? For Question 2: I need to show all the records from a table to the users (that's part of the user requirement). Therefore i've to use both TIBTable and TDbgrid component. The problem is that there's only 3 records in that table, but i wonder why it tooks so long for the system to load it . Thanks. Jonas Raoni wrote: On 5/19/05, soonhuat ong wrote: Man, your English is worse than mine hehe... Just a question, why don't you use Firebird [http://www.firebirdsql.org] instead of Interbase? > Question 1: > I have develop the a stand-alone application using Interbase. Now i want to convert it to > client-base application, how do i do that ?? Let's assume my IP address is > 192.182.3.207, and the server machine name is 'MyServer' ... So......... What's your main problem? Besides the instalation process (installing and starting the database on the server, and adding the comunication dll to your system folder on the clients), you just need to feed the correct ip address to your application and make sure that there's no firewall blocking the interbase port on the server... There's really nothing to do :) Here I use ZeosLib to connect with firebird, it's pretty nice... But if you want to have a very fast communication, take a look on IBObjects... Since it was made for interbase/firebird there must be few layers and work arounds to support other databases ;] > Question 2: > In my standalone application, i've found that my application is way too slow to show a > form with data.. The following is basically what i do > Drop a TIBTable, TIBTransaction, TDatabase, TDatasource and DBGrid component on a > frmMyForm1. Grids, tables, etc... All those sequential controls/commands aren't nice to be used with any SQL database, so, try to avoid using such things (specially in a client/server application), the problems and slowlyness will grow together with the users of your program =] Try to just ask something to the database when you really need to (I mean, dont open huge queries at initialization... like "select * from table"), try to page the results and filter everything... I mean, don't give to the user a list full of clients, but a search form =) You can see very nice patterns on the web development, take a look on how everything is done and just copy the behaviour on your program... Things will run very fast ;] -- "ME ALIMENTE [http://br-linux.org/noticias/002750.html] hehe" "Invente, Tente!!! Fa�a um c�digo eficiente" (Jonas Raoni haha) Jonas Raoni Soares Silva --------------------------- Desenvolvedor de aplica��es jonasraoni at gmail dot com http://www.joninhas.ath.cx:666 ----------------------------------------------------- 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 the Yahoo! Terms of Service. --------------------------------- Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone. [Non-text portions of this message have been removed] ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] ----------------------------------------------------- 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/
