Welcome! Log In Create A New Profile

Advanced

Webdev with oledb to MSSQL, access very slow

Posted by PETER ZHOU 
Forum List Message List New Topic
PETER ZHOU
Webdev with oledb to MSSQL, access very slow
July 22, 2008 03:46AM
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

Reply Quote
Newer Topic Older Topic
Author:

Your Email:


Subject:
Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: