Re: how to calculate bandwidth requirement for client-server applicati

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: David G. (david_nospam_at_nospam.com)
Date: 09/20/04 

Date: Mon, 20 Sep 2004 11:44:35 -0400

kburito wrote:
> I am writing a client-server desktop application.
> Front end is developed in VB
> Back end database is using SQL 2000
> The project is being developed using Classes.
>
> The application will be accessed by 1,000+ users using a Virtual
> Private Network to connect to the SQL database.
>
> How to I calculate the Bandwidth requirement per user per transaction
> for my application?
>
> Please advise on any tools that can be used to Find out the above
> Information? Thanks.

A call to the database should be pretty small. Use stored procedures (no
server API cursors and the like), make sure result sets are as small as
possible. That means, don't include extraneous columns or unnecessary
rows in the result sets. Also, eliminate all Order By operations on
queries if the application is more than capable of sorting any needed
data itself.

Use read-only, forward-only result sets exclusively and
update/insert/delete data from other stored procedures.

Always fetch all result set data immediately and then process after
everything is fetched.

Never use Parameters.Refresh() type methods from ADO as they require a
lot of interrogation of the database and are slow. Create your
parameters programmatically.

You can use the Show Client Statistics option in Query Analyzer to see
client data for a particular call. 

-- 
David Gugick
Imceda Software
www.imceda.com

Relevant Pages

  • Re: Dont understand what version of SQL to install
    ... I created a database using sql 2005 express edition. ... With that in mind - could you use SQL Server 2008 Developer Edition? ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)
  • Re: Serious errors with Create view command
    ... the database is opened? ... There's no database on earth that behaves that way! ... What on EARTH does the option of 'Edit Stored procedures' do? ... I can't paste it INTO the view designer sql view ...
    (microsoft.public.fox.helpwanted)
  • Re: Dont understand what version of SQL to install
    ... but "moving" a database implies a degree of automation. ... Principal SQL Infrastructure Consultant ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)
  • Re: Transaction Oriented Architecture (TOA)
    ... OOP is not required to wrap SQL. ... of stored procedures to act as an API for application programmers ... writing code against the database. ... With a well-defined API in place, ...
    (comp.object)
  • Re: Get all stored procedures
    ... For SQLSERVER, we can use the following SQL statement to query the SP ... objects of a certain database: ... Microsoft Online Support ... | Thread-Topic: Get all stored procedures ...
    (microsoft.public.dotnet.framework.adonet)