Solved

performance of a VB app in Sybase on Novell Network

Posted on 1998-07-15
5
200 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
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…
Suggested Courses
Course of the Month9 days, 23 hours left to enroll

623 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