Solved

performance of a VB app in Sybase on Novell Network

Posted on 1998-07-15
5
196 Views
Last Modified: 2010-05-03
Does anyone have any data regarding what would be reasonable performance standards for a VB 5.0 app on a SyBase Server in a Novell network environment?

Pertinent data:  50-75 users,  10%  using server intensive queries.
Data are records from a flat database file into a VB 5 relational database.
Server is 12 Gigs  6 1.7 Gig partitions for the database
256 K physical memory  (no more slots available)
Workstations are 486/66 with 10 megabit cards running Win95B
Average record is approximately 40kb parsed into 75 fields.
0
Comment
Question by:docmitch
  • 3
  • 2
5 Comments
 
LVL 1

Accepted Solution

by:
brunchey earned 200 total points
ID: 1465921
I would say check the page locking settings on the Novell server, this can affect performace of the database, so set the number as high as you can.  Ignore the novell manuals about how high the page locking settings can be, try a huge number and see if it sticks.  I think that your client PCs might slow you down a little bit with the 486 s that you are using, but I don't think that it will be that bug of a problem
I am wondering where you got a VB5 relational database?  
0
 

Author Comment

by:docmitch
ID: 1465922
Note for Brunchey,  thanks for the input  (I had not considered that, mostly we seem to have Sybase problems)  The issue I am trying to resolve goes beyond your response.  Also,  the VB5 app is a custom designed specialized progrma based on a previous app from VB 3.

General, I would still appreciate more input, and can provide some additional details if helpful.
0
 
LVL 1

Expert Comment

by:brunchey
ID: 1465923
Are you looking for a utility to measure performance?
0
 

Author Comment

by:docmitch
ID: 1465924
I haven't considered one, What would you suggest?  I would like to know how rapidly data is retrieved from the Server,, what a reasonable refresh rate is for the various forms, especially grid forms, and what the effect of queries or other Server intensive activities are on retrieval.  Server is a dedicated device, no other functions except for this app.
0
 
LVL 1

Expert Comment

by:brunchey
ID: 1465925
Well first off I would avoid all bound controls unless it is a recordset that will be about 175-200 or more, after that the .ADD method of any control in a loop is much slower than a  bound control.  Alot of it depends upon your queries and how efficient they are, If you are using RDO 2 you could get some asynchronous queries going for the longer ones and then when they return they will fire the query_complete method from this you could then fill the grid.  But basically, I think it will come down to how efficiently the queries are.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question