PROFESSIONAL NEWSGROUPS
WINDEV
,
WEBDEV
and
WINDEV Mobile
Home
|
Recent messages
|
Connect
|
Sign out
|
English
Home
→
WINDEV (earlier versions)
→
SQL connection
SQL connection
Started by Noupieple Hugues, Mar., 25 2009 7:56 AM - 1 reply
Connect yourself…
Noupieple Hugues
#1
Posted on March, 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
Report
0
0
Christian Potvin
#2
Posted on April, 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
Report
0
0
→ Go back to WINDEV (earlier versions)
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (earlier versions)
Français
English
Español
Portuguesa
Close this window
Search type
Only topics
All the messages
Search period
Any time
Past hour
Past 24 hours
Past week
Past month
Past year
Cancel
Preview of your message
Adding an image
Import an image from a URL
Send an image from a file of your disk
Drop a file or click "Browse..."
or
Cancel
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Text