PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEV, WEBDEV e WINDEV Mobile

Inicio | Mensagens recentes | Conecte-se... |  | Português FR
Inicio → WINDEV (versões anteriores) → SQL connection
SQL connection
Iniciado por Noupieple Hugues, mar., 25 2009 7:56 AM - 1 resposta
#1
Publicado em março, 25 2009 - 7:56 AM
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 em abril, 01 2009 - 9:31 AM
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
→ Voltar para WINDEV (versões anteriores)