What sofware to encrypt whole drives, Google drive folder, keeping access on Android and good performances? [on hold]

I would like to encrypt my drives and data on Windows 10, but I need some recommendation to use the appropriate software(s).

  • On my system drive, I have the "Backup and sync" Google software and the synchronized Google Drive folder. But I absolutely need to let the folder content readable from my phone at any time. If I encrypt the whole drive, will this folder be synchronized as encrypted? If yes, is it possible to decrypt files from Google Drive on the fly on Android?

  • I also have a "Media" SSHD (with my Pictures and Videos folders, and video editing stuff), a "Backup" SSHD (which contains the FileHistory Windows folder), and a "Virtual machines" SSHD. Note that I need to keep good performances with all of them if I encrypt them, regardless of the method.

I think that the most important folders to encrypt are Google Drive, Pictures, Videos and FileHistory. But I don’t know if whole drive encryption will be better and more appropriate.

For Windows, I found "Bitlocker" and "VeraCrypt", but if all files are encrypted, I won’t be able to decrypt Google Drive folder content on Android.

For Google Drive, I found "Boxcryptor", "Cryptomator", and "GoodSync" which work on Windows and Android, but which seems to be specific to cloud storage.

  • What folders or drives must I/can I encrypt to keep good performances?
  • What software(s) do you advise me to use? Do I have to use two sofwares to fit my requirements, or do you have any other recommendation?

Thanks!

Can a Bard/Barbarian use Performances while raging in combat?

Yes, you read that right. I’ll also mention that when the character is made, it’ll be 7th level, so the levels of Bard and Barbarian will be split. She likes the idea of raging to greatly increase her effectiveness in combat, but also likes the performance system in Pathfinder, so I’m trying to make it work. Now, I know that raging as a barbarian makes Charisma, Dexterity, and Intelligence based skills unusable (except Acrobatics, Fly, Intimidate, and Ride), so that rules out Performance checks because they are Charisma based. I was looking through the wording though and it looks like some of the Bardic Performances and some of them don’t seem to require a check. For example: Inspire Courage reads…

A 1st level bard can use his performance to inspire courage in his allies (including himself), bolstering them against fear and improving their combat abilities. To be affected, an ally must be able to perceive the bard’s performance. An affected ally receives a +1 morale bonus on saving throws against charm and fear effects and a +1 competence bonus on attack and weapon damage rolls. At 5th level, and every six bard levels thereafter, this bonus increases by +1, to a maximum of +4 at 17th level. Inspire courage is a mind-affecting ability. inspire courage can use audible or visual components. The bard must choose which component to use when starting his performance.

Nowhere in that text is a Perform check required and the only condition to continue a Bardic Performance is a free action, so this should be possible right? A few performances do either require the Perform check (Countersong for example), and others conflict with the concept of Rage (Fascinate requires no Perform check, but also doesn’t work in combat, which a Barbarian should DEFINITELY be doing if they are raging). I’m fairly new myself, so I’m not quite sure of a lot of nuances to this, like whether you can make Perform checks while brandishing a Greatsword, if this particular class combination would work, and if it did, what combination of levels should be used. Any help would be greatly appreciated.

Prepared statements and terrible performances

There was an application that was changed, so that all queries are performed using prepared statements, rather than regular statements. What happens is that, for every query, the prepared statement is created, used once, dumped.
This is obviously bad for performances, but it is much worse than I could expect.
Please tell me why this query takes 12 seconds on average to execute as prepared statement:

select top 1 * from Object1 where (Column1 = ?) 

You can see the plan here:

https://www.brentozar.com/pastetheplan/?id=B15cABISr

The table is about one million rows, a few kbytes every row, has a PK and only 4 indexes, including a non-clustered, non-unique index on Column1

What can I do to improve the performances, without returning to regular statements?

Starting multiple bardic performances in a single round

Bardic Performance reads as follows:

Starting a bardic performance is a standard action, but it can be maintained each round as a free action. Changing a bardic performance from one effect to another requires the bard to stop the previous performance and start a new one as a standard action. A bardic performance cannot be disrupted, but it ends immediately if the bard is killed, paralyzed, stunned, knocked unconscious, or otherwise prevented from taking a free action to maintain it each round. A bard cannot have more than one bardic performance in effect at one time.

At 7th level, a bard can start a bardic performance as a move action instead of a standard action. At 13th level, a bard can start a bardic performance as a swift action.

I’m going to play a Sound Striker and my plan is to use Weird Words an offensive bardic performance as a standard action and then use Inspire Courage to buff my party as a movement action.

Is that possible? Is there any rule that prevents me from starting more than 1 bardic performance per round?

How many bardic performances extra does a Half-elf gain?

I am new to Pathfinder and want to make sure I am reading these effects correctly. So a bard gets a number of bardic performances per day as listed here:

He can use this ability for a number of rounds per day equal to 4 + his Charisma modifier. At each level after 1st a bard can use bardic performance for 2 additional rounds per day

As a half-elf with bard as my favored class, I should also get the following at each level up:

Add +1 to the bard’s total number of bardic performance rounds per day.

If I am reading this correctly, that means I get 4+CHA mod + 1 at 1st level, then an additional 3 at each level thereafter. This just seems like a large change since it is a 50% increase in how many I get each level so I am worried I made a mistake somewhere.