In the early game you use cavalry mainly for occupations.
At this stage an army without cavalry takes too long... Once you get guards, cavalry seems less important. (to the point where I'd only use that for my colonials).
Amount of artillery depends on the size of your armies, and the big guns tech. Art is good in the later game when the frontage is small, but in the beginning, large infantery forces do better.