Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Some questions
Thu, Jan 31 2019 5:45 AMPermanent Link

Jose Eduardo Helminsky

HPro Informatica

Hi guys. I am pretty new to ElevateDB (but old from DBISAM)

I have some questions:

1) What the meaning of "Show database catalog information" in the server configuration (edbsrvr.ini) ?
What the impact of removing it from the configuration ?

2) How can I install 2 (two) instances (services) of edbsrvr ? I have already tried with the combination edbsrvr2.exe and edbsrvr2.ini but I can not install the second instance of service receiving "the service name is already in use"

Thanks in advance
Eduardo
Thu, Jan 31 2019 8:16 AMPermanent Link

Raul

Team Elevate Team Elevate

On 1/31/2019 5:45 AM, Jose Eduardo Helminsky wrote:
> 1) What the meaning of "Show database catalog information" in the server configuration (edbsrvr.ini) ?
> What the impact of removing it from the configuration ?

This maps to this setting - see link here

https://www.elevatesoft.com/manual?action=viewprop&id=edb2&product=rsdelphiwin32&version=10R&comp=TEDBEngine&prop=ShowDatabaseCatalogInfo

This property allows you to specify whether database catalog character
set and version information should appear in the Databases system
information table.

Setting this property to False can significantly improve the performance
of the loading of the Databases system information table when there are
a lot of databases in a configuration. This is because ElevateDB has to
open the database catalog for each database in order to read the
character set and version number.



> 2) How can I install 2 (two) instances (services) of edbsrvr ? I have already tried with the combination edbsrvr2.exe and edbsrvr2.ini but I can not install the second instance of service receiving "the service name is already in use"

See this link

https://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=Starting_Configuring_Server

Section on "Multiple Server Instances" but basically you need to specify
/name=<Server Instance Name> parameter

Note that you cannot use Global File I/O Buffering and multiple
instances since that one requires exclusive access by a single process.


Raul
Thu, Jan 31 2019 9:11 AMPermanent Link

Jose Eduardo Helminsky

HPro Informatica

Raul

Thank you very much
Image