Infralution Support Forum Index Infralution Support
Support groups for Infralution products
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

How to speed up License Tracker with SQL Server

 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Infralution Support Forum Index -> Licensing FAQ
View previous topic :: View next topic  
Author Message
Infralution



Joined: 28 Feb 2005
Posts: 5027

PostPosted: Thu Oct 07, 2010 12:58 am    Post subject: How to speed up License Tracker with SQL Server Reply with quote

If you have installed SQL Server as your database backend for SQL Server and find that License Tracker performance is very slow (takes a long time to switch between tabs) then setting the following options can improve performance:
  • Show Sales Totals => false
  • Maintain selection on Sort => false
  • Load Child Records on Expand => true
  • Filter Data Automatically => true

The last option automatically displays a dialog to allow you to filter the data that will be displayed in the License Tracker Customer, Sales and License Keys tabs before they are displayed. This can greatly improve performance by reducing the amount of data that needs to be transmitted from the SQL server to the application.

If the performance is still is very slow then you may need to enable TCP/IP protocol for SQL Server using Sql Server Configuration Manager. Some customers have reported that enabling TCPIP protocol can have dramatic improvements on the speed of the SQL Database.

See the following thread for more detail:

http://www.infralution.com/phpBB2/viewtopic.php?t=1734

You should also ensure you are running the latest version of ILS. There were significant improvements to performance when using SQL Server in version 5.11.0
_________________
Infralution Support
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Infralution Support Forum Index -> Licensing FAQ All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group