BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  network performance          BorlandTalk.com Forum Index -> Delphi Deployment View previous topic :: View next topic   Author Message Jorge Novoa Guest Posted: Mon Jul 31, 2006 8:10 am    Post subject: network performance how can i give better performance when i develop network apps., and get best memory resources to avoid slow apps. Back to top Bill Todd Guest Posted: Mon Jul 31, 2006 5:24 pm    Post subject: Re: network performance Jorge Novoa wrote: Quote: how can i give better performance when i develop network apps., and get best memory resources to avoid slow apps. 1. Use a SQL database server. 2. Employ client/server design techniques. If you want a more useful answer you need to provide a lot more information about the tools you are using (what database for instance) and what the app does that is slow. -- Bill Todd (TeamB) Back to top Arie Zilberstein Guest Posted: Tue Aug 01, 2006 8:11 am    Post subject: Re: network performance Hi, You can leverage high-end solutions by collaborating on team-based, market-shaping methodologies. Regards, Arie "Jorge Novoa" <pippen_8 (AT) todito (DOT) com> wrote in message news:44cd9953$1 (AT) newsgroups (DOT) borland.com... Quote: how can i give better performance when i develop network apps., and get best memory resources to avoid slow apps. Back to top JORGE NOVOA Guest Posted: Thu Aug 03, 2006 10:53 pm    Post subject: Re: network performance "Bill Todd" <no (AT) no (DOT) com> wrote: Quote: Jorge Novoa wrote: how can i give better performance when i develop network apps., and get best memory resources to avoid slow apps. 1. Use a SQL database server. 2. Employ client/server design techniques. If you want a more useful answer you need to provide a lot more information about the tools you are using (what database for instance) and what the app does that is slow. -- Bill Todd (TeamB) I use interbase to develop database apps. I thought i applied some techniques but i haven´t enough knwoledge about client/server technologies, i used corba in one app. weel, i always used tquerys(tzquery, tibquery, tquery) and it metods and properties to perform necesary tasks, connections(bdeconnection, tzconn., etc.), clientdataset(just once i used) and datasetprovider(just once i used) to communicate application to database server The apps. become slow when its loads, when its performs some queries and when the apps. have some time running. Back to top JORGE NOVOA Guest Posted: Thu Aug 03, 2006 10:59 pm    Post subject: Re: network performance "Arie Zilberstein" <azilberstein (AT) mercury (DOT) com> wrote: Quote: Hi, You can leverage high-end solutions by collaborating on team-based, market-shaping methodologies. Regards, Arie "Jorge Novoa" <pippen_8 (AT) todito (DOT) com> wrote in message news:44cd9953$1 (AT) newsgroups (DOT) borland.com... how can i give better performance when i develop network apps., and get best memory resources to avoid slow apps. i don´t work for a design or develop software company, and i had to learn by my own and it´s to hard Back to top Bill Todd Guest Posted: Thu Aug 03, 2006 11:31 pm    Post subject: Re: network performance JORGE NOVOA wrote: Quote: I use interbase to develop database apps. I thought i applied some techniques but i haven4t enough knwoledge about client/server technologies, i used corba in one app. For a quick start in C/S design read http://community.borland.com/article/0,1410,28160,00.html Quote: weel, i always used tquerys(tzquery, tibquery, tquery) and it metods and properties to perform necesary tasks, connections(bdeconnection, tzconn., etc.), clientdataset(just once i used) and datasetprovider(just once i used) to communicate application to database server The apps. become slow when its loads, when its performs some queries and when the apps. have some time running. What do you mean by "when it loads"? Do you mean when the application starts or do you mean when the number of simultaneous users increases? If the app slows down after it has been running for some time you need to look at the information in the IB Performance Monitor to determine why. You can also get the database header statistics at the time the app is running slow and post them here. You should also read Craig Stuntz's optimization papers at http://blogs.teamb.com/craigstuntz/articles/IBOptimization1.aspx -- Bill Todd (TeamB) Back to top Jorge Novoa Guest Posted: Fri Aug 04, 2006 6:18 am    Post subject: Re: network performance "Bill Todd" <no (AT) no (DOT) com> wrote: Quote: JORGE NOVOA wrote: I use interbase to develop database apps. I thought i applied some techniques but i haven4t enough knwoledge about client/server technologies, i used corba in one app. For a quick start in C/S design read http://community.borland.com/article/0,1410,28160,00.html weel, i always used tquerys(tzquery, tibquery, tquery) and it metods and properties to perform necesary tasks, connections(bdeconnection, tzconn., etc.), clientdataset(just once i used) and datasetprovider(just once i used) to communicate application to database server The apps. become slow when its loads, when its performs some queries and when the apps. have some time running. What do you mean by "when it loads"? Do you mean when the application starts or do you mean when the number of simultaneous users increases? when the application starts, and there is not a lot of simultaneous users at same time, just 3 or 4 max., thats the weird thing. If the app slows down after it has been running for some time you need to look at the information in the IB Performance Monitor to determine why. You can also get the database header statistics at the time the app is running slow and post them here. You should also read Craig Stuntz's optimization papers at http://blogs.teamb.com/craigstuntz/articles/IBOptimization1.aspx -- Bill Todd (TeamB) altought this happens because the compute's resources and memory are saturated, however im going to check the IB performance monitor Back to top Bill Todd Guest Posted: Fri Aug 04, 2006 7:58 am    Post subject: Re: network performance If it takes a long time for the application to load one way to find the problem areas is to set a breakpoint on the first line of the main form's OnCreate event handler and step through the code to see which lines take a long time to execute. My guess is that you are opening queries that retrieve a lot of data but that is just a guess. How do you know that the computer's resources and memory are saturated? What tool are you using to measure resource and memory use and what data is the tool providing? -- Bill Todd (TeamB) Back to top Jorge Novoa Guest Posted: Fri Aug 04, 2006 8:12 am    Post subject: Re: network performance "Bill Todd" <no (AT) no (DOT) com> wrote: Quote: If it takes a long time for the application to load one way to find the problem areas is to set a breakpoint on the first line of the main form's OnCreate event handler and step through the code to see which lines take a long time to execute. My guess is that you are opening queries that retrieve a lot of data but that is just a guess. There is no way to set a breakpoint, because the computers where the program are running just have the executable and not delphi installed. in the computer where the code founds, the app. run fast with breakponits or without it, and thats the reason why i couldn't determinate the slow behaviour Quote: How do you know that the computer's resources and memory are saturated? What tool are you using to measure resource and memory use and what data is the tool providing? -- Bill Todd (TeamB) i guess, some of that computers are a little bit old, besides through the years i notice that any app. running for a long time becomes slow even it been programmed on vb, c++, delphi, etc., its just a thought Back to top Bill Todd Guest Posted: Fri Aug 04, 2006 7:48 pm    Post subject: Re: network performance What version of Windows are the slow computers running? Are the fast computers and the slow computers connecting to the same InterBase server? -- Bill Todd (TeamB) Back to top JORGE NOVOA Guest Posted: Sat Aug 05, 2006 11:39 pm    Post subject: Re: network performance "Bill Todd" <no (AT) no (DOT) com> wrote: Quote: What version of Windows are the slow computers running? Are the fast computers and the slow computers connecting to the same InterBase server? -- Bill Todd (TeamB) Windows 98, the slow ones, and xp de fast one the slow computers are connected to interbase 6 and the fast computer to ib 7.1. The fast computer its my personal notebook where i develop and is not connected to the slow computers network. Back to top Bill Todd Guest Posted: Sun Aug 06, 2006 12:13 am    Post subject: Re: network performance JORGE NOVOA wrote: Quote: Windows 98, the slow ones, and xp de fast one the slow computers are connected to interbase 6 and the fast computer to ib 7.1. The fast computer its my personal notebook where i develop and is not connected to the slow computers network. Comparing IB 6 across a network to IB 7.1 on a local hard drive is about the same as comparing a Cessna 150 to a 747. Such a comparison means little. There is no performance monitoring in IB 6. The only thing you can do is look at the header statistics when the app is running slow and see if that shows anything. There is nothing else I can do to help with the information you have provided. My guess is that you have application design problems but since you cannot produce the slow performance in your development environment there is no way to determine what the problems are other than by looking at the headerstatistics and examining your application code in detail. You should start by reading the papers I referenced in my earlier message then try to set up a test environment using IB 7.1 (you should upgrade to 7.5.1, a free upgrade) and the same database the customer is using. Put IB and the database on another machine on a network of about the same speed as the one your client is using and see if the performance is poor. Then start looking for the reason. -- Bill Todd (TeamB) Back to top Student Guest Posted: Mon Aug 21, 2006 11:31 pm    Post subject: Re: network performance "Jorge Novoa" <pippen_8 (AT) todito (DOT) com> wrote: Quote: how can i give better performance when i develop network apps., and get best memory resources to avoid slow apps. Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi Deployment All times are GMT Page 1 of 1   Jump to: Select a forum C++ Builder Newsgroups----------------C++ BuilderC++ Builder (ActiveX)C++ Builder (Announcements)C++ Builder (Command Line Tools)C++ Builder DatabasesC++ Builder Databases (ADO)C++ Builder Databases (Desktop)C++ Builder Databases (InterBase Express)C++ Builder Databases (Multi-Tier)C++ Builder Databases (SQL Servers)C++ Builder (Graphics)C++ Builder (IDE)C++ Builder (Internet)C++ Builder (Internet Socket)C++ Builder (Internet Web)C++ Builder (Jobs)C++ Builder (Language)C++ Builder (Language C++)C++ Builder (Compatibility with MFC)C++ Builder (Native API)C++ Builder (Non-Technical)C++ Builder (Students)C++ Builder (Third Party Tools)C++ Builder (Upgrade)C++ Builder (VCL)C++ Builder (VCL Components Usage)C++ Builder (VCL Components Development)C++ Builder (VCL Usage)C++ Builder (WinAPI)C++ Builder Installation Delphi Newsgroups----------------Delphi (General)Delphi ActiveX Controls UsageDelphi ActiveX Controls DevelopmentDelphi As400Delphi DatabasesDelphi Databases (ADO)Delphi Databases (dbExpress)Delphi Databases (Desktop)Delphi Databases (InterBase Express)Delphi Databases (Multi-Tier)Delphi Databases (SQL Servers)Delphi DeploymentDelphi GraphicsDelphi IDEDelphi InternationalizationDelphi InternetDelphi Internet Isapi-WebBrokerDelphi Internet WebSnapDelphi Internet WinsockDelphi JobsDelphi Language BASMDelphi Language ObjectPascalDelphi Model Driven Architecture (General)Delphi Model Driven Architecture (Third Party)Delphi MultimediaDelphi Native APIDelphi Non-TechnicalDelphi ObjectPascalDelphi OLE AutomationDelphi OO designDelphi OpenToolsAPIDelphi Reporting-ChartingDelphi RTLDelphi StudentsDelphi TeamSourceDelphi Thirdparty ToolsDelphi Thirdparty Tools (General)Delphi Thirdparty Tools (IntraWeb)Delphi Thirdparty Tools (RaveReports)Delphi UpgradeDelphi VCLDelphi VCL ComponentsDelphi VCL Components UsingDelphi VCL Components WritingDelphi WebServices SOAPDelphi WinAPIDelphi XMLDelphi Installationcomp.lang.pascal.delphi.components.misccomp.lang.pascal.delphi.components.usagecomp.lang.pascal.delphi.components.writingcomp.lang.pascal.delphi.databasescomp.lang.pascal.delphi.misccomp.sources.delphi JBuilder Newsgroups----------------JBuilderJBuilder AnnouncementsJBuilder Applet IssuesJBuilder As400JBuilder CompilerJBuilder CORBA/RMIJBuilder DatabasesJBuilder DB SwingJBuilder DebuggerJBuilder DeploymentJBuilder DocumentationJBuilder EnterpriseJBuilder HandheldJBuilder IDEJBuilder JavaJBuilder JavaAPIJBuilder Java LanguageJBuilder Java SwingJBuilder Java BeansJBuilder Java Beans UsageJBuilder Java Beans DevelopmentJBuilder JBCLJBuilder JDataStoreJBuilder JobsJBuilder LinuxJBuilder MacintoshJBuilder & MobileSetJBuilder MultiLingual AppsJBuilder Non-TechnicalJBuilder OpenToolsJBuilder Servlets (JSP)JBuilder StudentsJBuilder Team DevelopmentJBuilder Thirdparty ToolsJBuilder UpgradeJBuilder Installation InterBase Newsgroups----------------InterBaseInterBase Bug DiscussionInterBase GeneralInterBase IBConsoleInterBase OpenSourceInterBase ReplicationInterBase SQLInterBase ThirdpartyInterBase Installation Miscellaneous Borland Newsgroups----------------AppCenterAppServerEnteraVisiBroker  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.