Solved

performance of a VB app in Sybase on Novell Network

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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
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…

751 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