PC SOFT

FOROS PROFESIONALES
WINDEV, WEBDEV y WINDEV Mobile

Inicio | Mensajes recientes | Conéctese... |  | Español FR
Inicio → WINDEV (versiones precedentes) → SQL connection
SQL connection
Iniciado por Noupieple Hugues, 25,mar. 2009 07:56 - 1 respuesta
#1
Publicado el 25,marzo 2009 - 07:56
HeLlo,

I am using OLEDB to connect to an Sql server Database. The application is very slow. any tchnique to speed it without the native driver.

I am using Widev 11 Engish

Hugues
#2
Publicado el 01,abril 2009 - 09:31
Hi Hugues,
I don't use MSSQL very often but I had the same problem few times ago. The SQL tables had a huge lot of fields and my problems related to the HRead... instructions. When you do those instructions within the OLEDB access, they are converted to a 'SELECT FieldA, FieldB, FieldC.... From SQLFile...'
So if your files contains many fields, the SQL call generated is heavy and will surely slow your process, especially with poor indexes.
Now I only use dynamic SQL calls (HExecuteSQLQuery) directly from my Windev application to reach MSSQL data and everything works fine. I only select the fields that I need.

Hope this helps,
Christian

Noupieple Hugues a écrit dans le message de news <646a995f80806e6891e76fcff77578be@news.pcsoft> :
HeLlo,

I am using OLEDB to connect to an Sql server Database. The application is very slow. any tchnique to speed it without the native driver.

I am using Widev 11 Engish

Hugues
→ Volver a WINDEV (versiones precedentes)