Inventory database files, referred to as the XStudio Inventory Database, are owned exclusively by XStudio as a default; when XStudio is running, no other application is allowed access to these files. Any attempts to open, copy or delete these files will be denied by the operating system, as they are already opened exclusively by XStudio.
Making the database available to other applications, called "sharing," can be accomplished in two distinct ways. One method is to enable the XStudio Allow Remote Access property in the Inventory Manager Options section of Preferences, which causes XStudio to function as a database server. The other method is to use a separate stand-alone database server application, which implements a client/server relationship between XStudio and the database and makes the database available to other utility applications as well.
Inventory Database Sharing by Allowing Other Applications to Connect to XStudio
The easiest and most convenient method of sharing database information with another application is to enable the Allow Remote Access property in XStudio. Essentially, XStudio becomes a database server in addition to its other duties.
When XStudio is functioning as a database server, other utility applications designed for use with XStudio can connect to and view or modify the database depending on the utility application. The utility might be run on the same PC or might be connecting from some other PC. Consult the utility application software documentation for details on how to access the database hosted by XStudio.
Effects of Inventory Database Sharing
Sharing of the XStudio inventory database has minimal effects on the operation of XStudio and users need not change how they do things when working with XStudio. There are some possible side effects of database sharing to be aware of, though.
Performance
Performance of XStudio can be affected when the database is shared, in the following ways:
1.If XStudio is functioning as a database server in addition to its other duties, application response time could be a bit slower if one or more utility applications are connected and performing database-intensive tasks. This occurs because XStudio has to divide its attention between normal operations and serving the database requests of connected client applications.
2.When XStudio is functioning as a database server, clients connect via TCP and depending what client tasks are being performed, network traffic may increase significantly for short periods of time. This could cause temporary slowdowns in activities that use the network connection.
