General recommendation for performance ???

Classic Servoy
1

Did someone has a list of general recommandation about design for performance with SQL anywhere from SYBASE. ???

When index becomes useful ?

Did I see any difference if I try to make all the fields smaller like text 50 in place of text 100?

Is there a performance issue when I use mediafields in my table ?

and … ?

Thanks for your help.

DomTom

2

Hi DomTom,

Sybase Central has an index wizard that analyzes your table data and measures if an index speed things up.
It will then ask you if you want indexes on those columns or not. If you say yes it creates them for you.
It’s pretty neat. :)

Hope this helps.