OK, so my first post on the Integration Blog, isn't exactly about integrations but it is something I have been working with lately and have had some questions about so I thought it was a good jumping off point.
With SalesLogix and its ability to extend the database structure to support customizations it often grows in scope beyond what was originally designed, as far as the SQL back end is concerned. It is important to consider what the implications on server performance are when adding large data tables that require extensive lookup or query activity against them. SQL utilizes indexes to increase search performance. Without properly designed indexes on large data sets, SQL performance on a system can be decreased enough to cause a system wide slow down in applications utilizing the SQL server.
Read more