03-24-2009 11:53 AM - edited 03-24-2009 11:54 AM
Currently I am retrieving a list of all of the contacts and then cycling through the contacts' histories to determine if they belong to the user who is logged into my little reporting application. The problem is that there are 18000 contacts and it takes about 20 minutes to run. What I would prefer to do is to just query the histories directly and pass in a filter for the user that is logged in but I don't think this is possible since "GetHistories" requires a contact to be specified.
Is there a better way to approach this?
We are using ACT! 2009.
03-31-2009 02:21 AM
Myabe you could use the Act.Framework.CurrentACTOLEDB property to get the connection string to the OLEDB provider and carryout the query in a SQL statement resulting ina Datasource which you could attach to your custom report generator? The SQL query will be much faster than iterating through ACT! object collections. I think in Bill's blog he has a code snippet of conecting to the ACTOLEDB provider.