BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Very slow BDE access on XP          BorlandTalk.com Forum Index -> Delphi Databases (Desktop) View previous topic :: View next topic   Author Message Joe C Guest Posted: Wed Feb 04, 2004 11:43 am    Post subject: Very slow BDE access on XP Hi A customer of mine has been using BDE for some time without any problem. (peer-to-peer win2000 network) Recently they wanted to upgrade the machine which serves the Paradox tables for the Delphi app I wrote for them so we upgraded it with a new machine running XP Pro. Since then access via BDE has slowed to snail pace. It can take up to 30 seconds to run a filter on even a small table. This is especially noticeable from a couple of other XP machines on the network. I've read about oplocks problems on XP so I disabled oplocks on the server machine but to no avail. Is this a known problem with XP? I'd prefer to get it working with XP if this can be done - or is the long term solution to install win2000 on the server machine? Any help appreciated. Joe Back to top Jim Cullison Guest Posted: Wed Feb 04, 2004 3:22 pm    Post subject: Re: Very slow BDE access on XP Try disabling System Restore. It monitors many file extensions for changes, and I think I remember it including some that would be paradox files. Jim "Joe C" <nospam_joe (AT) appliancetrader (DOT) co.uk> wrote Quote: Hi A customer of mine has been using BDE for some time without any problem. (peer-to-peer win2000 network) Recently they wanted to upgrade the machine which serves the Paradox tables for the Delphi app I wrote for them so we upgraded it with a new machine running XP Pro. Since then access via BDE has slowed to snail pace. It can take up to 30 seconds to run a filter on even a small table. This is especially noticeable from a couple of other XP machines on the network. I've read about oplocks problems on XP so I disabled oplocks on the server machine but to no avail. Is this a known problem with XP? I'd prefer to get it working with XP if this can be done - or is the long term solution to install win2000 on the server machine? Any help appreciated. Joe Back to top heiko Luettge Guest Posted: Wed Feb 11, 2004 1:17 pm    Post subject: Re: Very slow BDE access on XP check this for the clients HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanWorkstationParam eter "UseUnlockBehind"=dword:0 "UseLockReadUnLock"=dword:0 I had a similar problem with speed (10 times slower). Then look in the filelist.xml (hidden file) in xp under c:windowssystem (?) for paradox extensions (db, px, xg0 ...) Heiko Back to top Joe C Guest Posted: Thu Feb 12, 2004 12:19 pm    Post subject: Re: Very slow BDE access on XP Thanks for the suggestion Jim. I have tried that and it hasn't made any real noticeable difference. I have however identified thats it the initial opening of a table that is the longest delay. I presume that for some reason the BDE is taking a long time to establish a lock on the NET file. Once the file is open then access is much faster. With regard to the OpLocks issue on XP - is disabling OpLocks on the server machine enough? or should all client machines also have OpLocks disabled? Also I'm using UNC for the locations of data directory/net file. All machines are either XP or 2000 so is this OK? or is it better to define a drive letter? Any help appreciated. Joe "Jim Cullison" <cullisonj_AT_posim_DOT_net> wrote Quote: Try disabling System Restore. It monitors many file extensions for changes, and I think I remember it including some that would be paradox files. Jim "Joe C" <nospam_joe (AT) appliancetrader (DOT) co.uk> wrote in message news:4020daec$1 (AT) newsgroups (DOT) borland.com... Hi A customer of mine has been using BDE for some time without any problem. (peer-to-peer win2000 network) Recently they wanted to upgrade the machine which serves the Paradox tables for the Delphi app I wrote for them so we upgraded it with a new machine running XP Pro. Since then access via BDE has slowed to snail pace. It can take up to 30 seconds to run a filter on even a small table. This is especially noticeable from a couple of other XP machines on the network. I've read about oplocks problems on XP so I disabled oplocks on the server machine but to no avail. Is this a known problem with XP? I'd prefer to get it working with XP if this can be done - or is the long term solution to install win2000 on the server machine? Any help appreciated. Joe Back to top Glenn Guest Posted: Thu Feb 12, 2004 12:59 pm    Post subject: Re: Very slow BDE access on XP Just a thought as this worked for me once... Have you tried deleting all .net and .lck files on all PC's? Regards Glenn "Joe C" <nospam_joe (AT) appliancetrader (DOT) co.uk> wrote Quote: Thanks for the suggestion Jim. I have tried that and it hasn't made any real noticeable difference. I have however identified thats it the initial opening of a table that is the longest delay. I presume that for some reason the BDE is taking a long time to establish a lock on the NET file. Once the file is open then access is much faster. With regard to the OpLocks issue on XP - is disabling OpLocks on the server machine enough? or should all client machines also have OpLocks disabled? Also I'm using UNC for the locations of data directory/net file. All machines are either XP or 2000 so is this OK? or is it better to define a drive letter? Any help appreciated. Joe "Jim Cullison" <cullisonj_AT_posim_DOT_net> wrote in message news:40210e02 (AT) newsgroups (DOT) borland.com... Try disabling System Restore. It monitors many file extensions for changes, and I think I remember it including some that would be paradox files. Jim "Joe C" <nospam_joe (AT) appliancetrader (DOT) co.uk> wrote in message news:4020daec$1 (AT) newsgroups (DOT) borland.com... Hi A customer of mine has been using BDE for some time without any problem. (peer-to-peer win2000 network) Recently they wanted to upgrade the machine which serves the Paradox tables for the Delphi app I wrote for them so we upgraded it with a new machine running XP Pro. Since then access via BDE has slowed to snail pace. It can take up to 30 seconds to run a filter on even a small table. This is especially noticeable from a couple of other XP machines on the network. I've read about oplocks problems on XP so I disabled oplocks on the server machine but to no avail. Is this a known problem with XP? I'd prefer to get it working with XP if this can be done - or is the long term solution to install win2000 on the server machine? Any help appreciated. Joe Back to top Joe C Guest Posted: Thu Feb 12, 2004 5:16 pm    Post subject: Re: Very slow BDE access on XP Thanks Glenn. I tried that but again still very much the same in terms of speed of access. Data integrity is very good with only a table corruption occuring like every 6 months or so... but the speed of access can just be painful at times. I've tried tweaking the BDE parameters up to try and improve performance too but still no joy. Joe "Glenn" <nospamhelp (AT) key-data (DOT) co.uk> wrote Quote: Just a thought as this worked for me once... Have you tried deleting all .net and .lck files on all PC's? Regards Glenn "Joe C" <nospam_joe (AT) appliancetrader (DOT) co.uk> wrote in message news:402b6f95$1 (AT) newsgroups (DOT) borland.com... Thanks for the suggestion Jim. I have tried that and it hasn't made any real noticeable difference. I have however identified thats it the initial opening of a table that is the longest delay. I presume that for some reason the BDE is taking a long time to establish a lock on the NET file. Once the file is open then access is much faster. With regard to the OpLocks issue on XP - is disabling OpLocks on the server machine enough? or should all client machines also have OpLocks disabled? Also I'm using UNC for the locations of data directory/net file. All machines are either XP or 2000 so is this OK? or is it better to define a drive letter? Any help appreciated. Joe "Jim Cullison" <cullisonj_AT_posim_DOT_net> wrote in message news:40210e02 (AT) newsgroups (DOT) borland.com... Try disabling System Restore. It monitors many file extensions for changes, and I think I remember it including some that would be paradox files. Jim "Joe C" <nospam_joe (AT) appliancetrader (DOT) co.uk> wrote in message news:4020daec$1 (AT) newsgroups (DOT) borland.com... Hi A customer of mine has been using BDE for some time without any problem. (peer-to-peer win2000 network) Recently they wanted to upgrade the machine which serves the Paradox tables for the Delphi app I wrote for them so we upgraded it with a new machine running XP Pro. Since then access via BDE has slowed to snail pace. It can take up to 30 seconds to run a filter on even a small table. This is especially noticeable from a couple of other XP machines on the network. I've read about oplocks problems on XP so I disabled oplocks on the server machine but to no avail. Is this a known problem with XP? I'd prefer to get it working with XP if this can be done - or is the long term solution to install win2000 on the server machine? Any help appreciated. Joe Back to top Edgar Rodriguez Guest Posted: Fri Feb 20, 2004 6:34 pm    Post subject: Re: Very slow BDE access on XP Change to Firebird!!! Back to top Bill Todd (TeamB) Guest Posted: Fri Feb 20, 2004 7:11 pm    Post subject: Re: Very slow BDE access on XP If you are running antivirus software try disabling it. If that helps then configure the antivirus software so it does not check the database files when they are opened. If your app is running in compatibility mode on the XP machines try not running in compatibility mode. From reports on the newsgroups there are many users running Paradox apps on XP without the problems you describe. -- Bill (TeamB) (TeamB cannot respond to questions received via email) 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 (Desktop) 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.