Should I take 500 mg of berberine before or after meals?

It's not going to make that big of a difference. Do whatever's more convenient. The changes are going to be very subtle.