Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #13463

Re: SQLServer VO2.5 x VO2.8

Path csiph.com!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From "Wolfgang Riedmann" <wriedmann@gmail.com>
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 <ivcf4pF1s12U1@mid.individual.net> (permalink)
References <db88e132-c7e6-4614-975b-17a0a41e0f2fn@googlegroups.com>
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

Show key headers only | View raw


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


-- 

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Find similar | Unroll thread


Thread

SQLServer VO2.5 x VO2.8 Antonio Falcao Neto <netofalcao.bezerra@gmail.com> - 2021-11-11 11:52 -0800
  Re: SQLServer VO2.5 x VO2.8 Jamal <nospam@example.com> - 2021-11-13 01:51 -0500
  Re: SQLServer VO2.5 x VO2.8 "Wolfgang Riedmann" <wriedmann@gmail.com> - 2021-11-14 13:52 +0100

csiph-web