PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV (précédentes versions) → SQL connection
SQL connection
Débuté par Noupieple Hugues, 25 mar. 2009 07:56 - 1 réponse
#1
Posté le 25 mars 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
Posté le 01 avril 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
→ Revenir à WINDEV (précédentes versions)