Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "Wolfgang Riedmann" Newsgroups: comp.lang.clipper.visual-objects Subject: Re: SetFilter cancels the default rdd Date: Mon, 5 Aug 2013 17:09:14 +0200 Lines: 27 Message-ID: References: <0018e291-a145-40e5-91fe-258609fc9d07@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Trace: individual.net DBeU4VFoGgH05HW4m+J2MQK4DSgfUllTpdSqBoZHOVI9AJgZY= Cancel-Lock: sha1:ZgwLak6rQC0/rgZofhie/A/pgMo= User-Agent: XanaNews/1.18.1.6 Xref: csiph.com comp.lang.clipper.visual-objects:5641 Hi Christian, > 2. > I have a problem with speed of this application - bbrowser works very > slow. When work 1 or 2 persons - it is OK; but when start to work 20 > simultaneously - the performance dramatically falls down. First - I > thought about changing the rdd : from ntx to cdx. Second - if it > does not help, to move the main database to sql; it will work in > mixed environment because old files are still in dbf. having 20 concurrent users on the same DBF will slow down, that is too much for DBF access. You have 2 possibilities: use ADS. This will cost some money, but you an maintain your application structure, or change to SQL. Probably this will cause a complete redesign of your app, because the approach for a positional database like DBFs and a relational database like SQL is too different. Wolfgang P.S. I'm using both DBFCDX and ADS in some projects, and MySQL and Oracle in other projects, so I'm speaking of own experience --