Solved

performance of a VB app in Sybase on Novell Network

Posted on 1998-07-15
5
194 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
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…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now