if you wan't to change it in X, then I have a soluution for you. For the console I don't know if you even can change the settings.
Put this in your X init script:
xset m acceleration treshold
Try experimenting with it (I have: xset m 2 4 and it works nice for me). For details see: man xset