A wet reckless, or any other criminal conviction, stays on your record forever. It only leaves when you have it expunged (you'll need to hire a DUI lawyer for this), which is usually good enough for what most people want. An expunged conviction no longer exists to most people (private parties), but it does stay on your record for government purposes. It stays on your DMV record for 10 years, whether you have it expunged or not. I am told that it stays on your insurance record for 3 years. You should hire a lawyer if you want to minimize the impact a conviction has on your record.
Agree with Matt on this one. It depends on what you mean by "record". Your DMV record? Your criminal record? Findable by those who look? Priorable? Probationary period? In Mojave the court generally sentences to probation from between 3-5 years. During that time, any violation of your terms of probation can cause a revocation and renewed penalty assessment. Priorable: 10 years. Finadable: Forever. Criminal Record: Forever. DMV: Forever, but priorable and viewable for limited times.