Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

performance of a VB app in Sybase on Novell Network

Posted on 1998-07-15
5
Medium Priority
?
201 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 400 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
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…
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…
Suggested Courses

688 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