BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Kiosk style app          BorlandTalk.com Forum Index -> Delphi Databases (InterBase Express) View previous topic :: View next topic   Author Message Dominic Guest Posted: Thu Mar 15, 2007 8:11 am    Post subject: Kiosk style app Hi I am developing a kiosk style application using Delphi 6 Pro,IBX 6.02 and Interbase 6.0.2.0. The application will be running on workstations in labour hire firms to allow job seekers to enter their employment details directly to the companies HR system. While the application may be "running" all day, the use will be very ,very light. My question relates to connecting to the database: I am quite aware of connection issues using multi-cpu/SMP/hyperthreading environments and IB 6.0.2.0 and while we do configure most of our clients with ib_affinity, we cannot guarantee that it will always be running. Also our backup procedures in our HR system require exclusive access to the database (wherever possible) when a backup is being performed. Backups are done regularly not because of system instability but because of the nature of the software (payroll and HR)- it allows users to quickly restore to a save point. Normally I would do a connect-insert/update-disconnect approach, but I don't want the user (job seeker) to have to experience delays when entering data. I was thinking of implementing some type OnIdle logic where the application would disconnect from the database after some period of in-activity and connect back to the database after some other period of in-activity or when required. The logic would be something like this: Application Starts Connect to Database No activity for 5 minutes - disconnect No activity for 15 minutes - connect No activity for 5 minutes - disconnect Application receives keystroke/mouse click - connect if disconnected. ------------------------------------- Is what I propose feasible/possible or should I just live with any connection issues the application may experience? Would implementing a connection thread help at all? Thanks for your time Dominc Back to top Craig Stuntz [TeamB] Guest Posted: Thu Mar 15, 2007 8:11 pm    Post subject: Re: Kiosk style app Dominic wrote: Quote: I am quite aware of connection issues using multi-cpu/SMP/hyperthreading environments and IB 6.0.2.0 and while we do configure most of our clients with ib_affinity, we cannot guarantee that it will always be running. Don't use ib_affinity; use imagecfg. You run it once before starting the server and you never need to do it again. Quote: Also our backup procedures in our HR system require exclusive access to the database (wherever possible) when a backup is being performed. Don't do this. Use gbak to backup the DB (while it's live) and then backup the gbk file with your other system. Don't backup the DB file with a process which requires exclusive access. Quote: Backups are done regularly not because of system instability but because of the nature of the software (payroll and HR)- it allows users to quickly restore to a save point. Do note that IB 2007 allows point-in-time recovery *while the DB is live.* Quote: Normally I would do a connect-insert/update-disconnect approach, but I don't want the user (job seeker) to have to experience delays when entering data. I was thinking of implementing some type OnIdle logic where the application would disconnect from the database after some period of in-activity and connect back to the database after some other period of in-activity or when required. Souncs like a recipe for data loss to me. I just don't see why you want to take the DB offline all the time. -- Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz Please read and follow Borland's rules for the user of their server: http://support.borland.com/entry.jspa?externalID=293 Back to top Bill Todd Guest Posted: Thu Mar 15, 2007 8:44 pm    Post subject: Re: Kiosk style app Get imagecfg.exe from \support\debug\i386 on your OS CD Then run from CMD: imagecfg -a 0x1 C:\Program Files\Borland\interbase\Bin\ibserver.exe to permanently make IBServer run on one 'CPU' -- Bill Todd (TeamB) Back to top Dominic Guest Posted: Fri Mar 16, 2007 5:41 am    Post subject: Re: Kiosk style app Hi Craig Quote: Don't use ib_affinity; use imagecfg. You run it once before starting the server and you never need to do it again. Ok. I have looked at this previously but was a bit worried because from my understanding imagecfg writes to the exe and changes the header. Quote: Don't do this. Use gbak to backup the DB (while it's live) and then backup the gbk file with your other system. Don't backup the DB file with a process which requires exclusive access. There seems to be some misunderstanding - we use TIBBackupService but we still recommend exclusive access. This is determined by simply checking to see if any connections are active to the database. We do however still allow the user to backup if "phantom" connections exist. We do not support zip or any other form of external backup mechanism in our application. Quote: Do note that IB 2007 allows point-in-time recovery *while the DB is live.* Ok, but for our purposes, IB 2007 would introduce a monetary hit to our customers that we couldn't justify. We are seriously looking at FB - this is a separate issued not to be discussed here Quote: Souncs like a recipe for data loss to me. I just don't see why you want to take the DB offline all the time. Not taking the DB offline - simply closing the active connection. Cheers Dominic Back to top Craig Stuntz [TeamB] Guest Posted: Fri Mar 16, 2007 7:21 pm    Post subject: Re: Kiosk style app Dominic wrote: Quote: Ok. I have looked at this previously but was a bit worried because from my understanding imagecfg writes to the exe and changes the header. It does; that's why you only have to run it once. Quote: Don't do this. Use gbak to backup the DB (while it's live) and then backup the gbk file with your other system. Don't backup the DB file with a process which requires exclusive access. There seems to be some misunderstanding - we use TIBBackupService but we still recommend exclusive access. Why? There is no need at all to shut down the DB when backing up with TIBBackupService. It's fine to do it live. -- Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz Please read and follow Borland's rules for the user of their server: http://support.borland.com/entry.jspa?externalID=293 Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi Databases (InterBase Express) 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.