Attachments are all compressed using the standard zip compression algorithm before being imported into the database, so anything that is not already in a compressed format will be significantly reduced in size when stored in the database. (FYI: Documents in pdf format, and graphics in jpg format, for example, are already compressed, so they will […]
|
||||
|
The following instructions are specifically for SOS Release 2010 and later. First, it is necessary to configure your user ID in the Admin Module (Users and Passwords) to allow access from 3rd party products (Access tab option “Grant read-only access from non-SOS products”). If you are not cleared for this type of access, you […] The upgrade to SOS 2010 is quite similar to previous SOS upgrades that you may have done. It does, however, replace your older Sybase database components with newer versions. In some cases that change will require a couple of post-installation steps, which are detailed below. All Installations, Including Network Workstations You may find that one […] Sorting To sort records by a column’s values and replace existing sort conditions that are applied to the current or other column(s), click the target column’s header, until an UP or Down Arrow icon is displayed within the header. The Up and Down Arrows indicate ascending and descending sort orders, respectively. To sort […]
[This discussion assumes that you are running SOS 2010 or later] The best and simplest option for getting optimal performance from a large database is to run it on a 64 bit Windows system with an abundance of RAM. Ideally, you would have enough RAM installed in your system so that the entire database […] The following recommendations should deliver adequate performance in each indicated category. If your implementation is particularly demanding, you want better than just “adequate” performance, or your database is large, you should increase both RAM and processor speed to compensate. Simultaneous usage of resource-hungry applications such as Microsoft Office also demand more RAM. Windows 32 […] To as great a degree as possible, the SOS system was designed to be self-correcting. In addition, the database in which your data are stored was specifically chosen for its proven track record for both reliability and performance. Nevertheless, electrical anomalies, hardware failures, and accidents of one kind or another can potentially create difficulties. Here […] The information in the Backing Up Your Data article is quite sufficient for most installations. The current document discusses advanced topics that will be of particular interest to those running the system in larger organizations with high data entry volume. The following topics include how to recover data entered since the most recent backup and […] Complete Sybase documentation for Sybase SQL Anywhere (SA) can be found by selecting Sybase Manuals on the Help menu in Office Manager (OM), Case Manager (CM), or Appointment Scheduler (AS). Alternatively, select Start > Programs > SOS Applications > Sybase Manuals. There are actually three SA guides: SQL Anywhere Server SQL Usage, which includes an […] Nothing that you do on your computer in the course of a day — or for that matter, a month — has anywhere near the significance of your backup procedure. A good backup will someday mean the difference between a minor inconvenience and a very costly disaster. It is only a matter of time before […] |
||||
Print Friendly