Path: csiph.com!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "Wolfgang Riedmann" Newsgroups: comp.lang.clipper.visual-objects Subject: Re: SQLServer VO2.5 x VO2.8 Date: Sun, 14 Nov 2021 13:52:41 +0100 Lines: 17 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 X-Trace: individual.net VBCVPmRniIrNDoWMpJb96gmwoe/q7wMwati45ccNRNGvwhJDE= Cancel-Lock: sha1:tx9QMcgHjXH0X15nnIENJYOA/Tw= User-Agent: XanaNews/1.18.1.6 Xref: csiph.com comp.lang.clipper.visual-objects:13463 Hi Antonio, > I have a very old system on VO2.5 on SQLServer. > I am switching to VO2.8. But performance on 2.8 is MUCH SLOWER. > Does anyone have any idea how to improve? try to set SqlSetStmtCursorType( SQL_CURSOR_DYNAMIC ) at the start of your program. Wolfgang --