multi-user applications

[hugh welford]

Hi - I am b-testing a community site, with currently 1,000 or so membership,
and low concurrency, say no more than 5 on-line at once.

The site is hosted on a shared server, which is sufferening from
intermittent accute slowness, affecting all other hosted sites as well as
mine. The finger of suspicion is pointing at me and possible sloppy code. As
this is the first site I have done of this nature, could someone recommend
reading matter (knowledge bases etc), especially coding samples, in
connection with data connections (opening and closing connections and
objects) and record locking issues, which if improperly coded, could
contribute to throughput bottlenecks due to inefficient use of resources so
that I can check out my pages and correct any nasties..

Any help greatly appreciated

Thanks in advance

Hugh

 

[Bob Barrows [MVP]]

Hi - I am b-testing a community site, with currently 1,000 or so
membership, and low concurrency, say no more than 5 on-line at once.

The site is hosted on a shared server, which is sufferening from
intermittent accute slowness, affecting all other hosted sites as
well as mine. The finger of suspicion is pointing at me and possible
sloppy code.

Have they shut your site down for the period of time required to determine
that your site is actually the problem?

As this is the first site I have done of this nature,
could someone recommend reading matter (knowledge bases etc),
especially coding samples, in connection with data connections
(opening and closing connections and objects) and record locking
issues, which if improperly coded, could contribute to throughput
bottlenecks due to inefficient use of resources so that I can check
out my pages and correct any nasties..

Start with www.aspfaq.com

 

[hugh welford]

thanks bob

Have they shut your site down for the period of time required to determine
that your site is actually the problem?

Start with www.aspfaq.com

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

 

[paul]

How about this so that only one user accesses the database at a time
although this is actually happens by default starting with ASP 3.0:
Buffer That Output by Charles Carroll
http://www.learnasp.com/advice/whybuffer.asp

Best regards,
J. Paul Schmidt, Freelance Web and Database Developer
http://www.Bullschmidt.com
Access Database Sample, Web Database Sample, ASP Design Tips