> Do these limits apply to the embedded server also or
> are there limitations that aren't covered on the
> page above?

There is no difference beyween embedded server and standalone one.

> Also, while these may be theoretical limits even for
> the embedded server, are there any practical limits
> that real-life practitioners are finding?

Yes, in database with size 1 terrabyte and bigger prepare operation
is slow (though it depends on size of table, not database as whole).

SY, SD.