HomeStar Bill of LadingFAQ'sMy Network Edition seems to be running very slow. What can be done about this?

8.5. My Network Edition seems to be running very slow. What can be done about this?

It could be that there is a large amount of data being passed as in old bill information in the database. You may want to try to purge some of the older data. This is an option in the program under the Main menu, File, Backup/Restore Data, Purge/Restore Old BOL's from/to System. Here you can remove older bills and can either permanently or temporarily purge the data based on a date selection.

About the only option that would speed up the whole process since you have many bills in the system is to upgrade the database software to the Client Server Version.  This software is from Sybase/SAP, called C/S Advantage Database.  It installs on your server and is made for this type of processing.  The cost of this database software runs around $650.00 for a 5 User version.  If you do not need the full 5 users version, just let us know as there are other versions available from 1 - Unlimited users with different pricing for each level.  It is the upgrade version of the Local Server version that we use in the BOL software.  One of the main difference is the database processing is handled on the server where the data resides and not on the local workstation that the software currently runs on.  This speeds things up dramatically as you do not have to pass all the data files back and forth from the storage location to the workstation and back and forth etc.  There is a 30 day trial version available from Sybase that you can download and install on your server so you can see the difference it makes if interested.  You can obtain this trial from SAP.  Here is the direct link: http://devzone.advantagedatabase.com/dz/content.aspx?key=1

Just click on the Evaluate option, then Trials.  Just fill out the information and it will allow you to download and install.  Just install it on your server that the Bill of Lading data files reside on.  It is very simple to install and run.  Hopefully this will solve your problem.  If you do this, and are satisfied of the results, you can just contact Sybase to purchase Just let them know the number of concurrent users you would need and they can quote you a price.

There also maybe something bottlenecking your network, but that would be a long shot.

 

 

About the only option that would speed up the whole process since you have many bills in the system is to upgrade the database software to the Client Server Version.  This software is from Sybase, called C/S Advantage Database.  It installs on your server and is made for this type of processing.  The cost of this database software runs $650.00 for a 5 User version.  If you do not need the full 5 users version, just let us know as there are other versions available from 1 - Unlimited users with different pricing for each level.  It is the upgrade version of the Local Server version that we use in the BOL software.  One of the main difference is the database processing is handled on the server where the data resides and not on the local workstation that the software currently runs on.  This speeds things up dramatically as you do not have to pass all the data files back and forth from the storage location to the workstation and back and forth etc.  There is a 30 day trial version available from Sybase that you can download and install on your server so you can see the difference it makes if interested.  You can obtain this trial from www.advantagedatabase.com.  Here is the direct link: http://www.sybase.com/products/databasemanagement/advantagedatabaseserver

 

 

This page was: Helpful | Not Helpful