Remove default settings in the GUI from Oracle/TPC-C to no database and workload

[jamiere-msft]

This is from our SQL Evangelist who does many live demos with HammerDB. He asked if we could set the defaults in the GUI to no database and no workload. It is a perception issue, not anything funcitonal.

[abondvt89]

Also an issue in the CLI.

[sm-shaw]

Currently this is configurable by updating the generic.xml file in the config directory. It needs to be set to a particular database and workload to initialize HammerDB as it associates the chosen database and workload with the functions that are called, so it cannot be blank, if it is it will use the default. Oracle/TPC-C is in the default generic.xml file, however this is only for historical reasons as this workload was done first. To change it after install you can change generic.xml - For example this would make SQL Server and TPC-H the default on subsequent startup:

   <benchmark>
        <rdbms>MSSQLServer</rdbms>
        <bm>TPC-H</bm>
   </benchmark>

So the question is - is this sufficient or would it be preferred to be configurable during install somehow?

[jamiere-msft]

Modifying the generic.xml file should be sufficient. I will check with the person who reported it to me and confirm. Jamie Reding | Microsoft SQL Server | 425-703-0510 From: Steve Shaw <[email protected]> Sent: Monday, June 3, 2019 8:21 AM To: TPC-Council/HammerDB <[email protected]> Cc: Jamie Reding <[email protected]>; Author <[email protected]> Subject: Re: [TPC-Council/HammerDB] Remove default settings in the GUI from Oracle/TPC-C to no database and workload (#55) Currently this is configurable by updating the generic.xml file in the config directory. It needs to be set to a particular database and workload to initialize HammerDB as it associates the chosen database and workload with the functions that are called, so it cannot be blank, if it is it will use the default. Oracle/TPC-C is in the default generic.xml file, however this is only for historical reasons as this workload was done first. To change it after install you can change generic.xml - For example this would make SQL Server and TPC-H the default on subsequent startup: <benchmark> <rdbms>MSSQLServer</rdbms> <bm>TPC-H</bm> </benchmark> So the question is - is this sufficient or would it be preferred to be configurable during install somehow? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FTPC-Council%2FHammerDB%2Fissues%2F55%3Femail_source%3Dnotifications%26email_token%3DAGMVUZKE2QCXVLYNHSCMCS3PYUZEXA5CNFSM4HIHJUR2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODWZX3NI%23issuecomment-498302389&data=02%7C01%7CJamie.Reding%40microsoft.com%7C48c32c809c9f4609e81c08d6e8370b97%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636951720449640621&sdata=9afQD1uKxgTDffVyjZ76M%2FJSmm7MuYSIX4MzUneQc%2B4%3D&reserved=0>, or mute the thread<https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAGMVUZP7GBKAPLECJAVMLITPYUZEXANCNFSM4HIHJURQ&data=02%7C01%7CJamie.Reding%40microsoft.com%7C48c32c809c9f4609e81c08d6e8370b97%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636951720449650625&sdata=5ySfS4lQmaCrPHDIaX9v75x2p%2F2V%2BVgI6VPugTFK4sw%3D&reserved=0>.

[jamiere-msft]

I confirmed that this is acceptable. Thanks!

[sm-shaw]

Issue closed as modifying generic.xml gives the desired functionality