Question about encryption and password protection

Howdy!

Couple quick questions:

1) How much does setting encryption cost in terms of speed of querying and cpu usage?
2) If encryption is not set, is the password "encrypted" when its sent with the initialization routine?

Thanks in advance!

1: Most agree on a 10 - 20 % performance hit (on devices), it is probably not noticeable on a desktop.

2: If a password is specifed, you are always using encryption

Password-or-Pwd-or-database password-or-ssceatabase password

The database password, which can be up to 40 characters in length. If not specified, the default value is no password. This property is required if you enable encryption on the database. If you specify a password, encryption is automatically enabled on the database.

|||Thanks for the reply!