PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → Webdev with oledb to MSSQL, access very slow
Webdev with oledb to MSSQL, access very slow
Débuté par PETER ZHOU, 22 juil. 2008 09:01 - Aucune réponse
#1
Posté le 22 juillet 2008 - 09:01
Hi,
I've developer webdev application connection to hyperfile classic..
1) used "gpwOpenConnection" with option 'hOledbSQLServer' & "HChangeConnection". works fine less than 10 users. But the moment is increased to 30 users or more...every record saving takes more than 2 mintues instead of 20 secs.
2) Do we need to declare any indexes on the MSSQL db server ?
Any suggestion ?
Regards,
PETER ZHOU
→ Revenir à WINDEV 2024