Connect!It ODBC SQL Server

[TimF]

Hi,



I am trying to evaluate Connect!It for a updating Problem Records between ServiceCenter and a table in a MS SQL Server Database using ODBC.



The issue I have is that the SQLServer database is so large (>50,000 objects) that the connector takes about 15 minutes to connect!



Any suggestions/workarounds...



thanks,



Tim

[tommy]

Enable the cache. This way Connect.It remembers the database structure.



You just need to remember and refresh the cache if the SQL server is changed.



This should hopefully reduce connect time.

[tommy]

For comparison I ran a litle test.



This was done on a 128KB isdn line so the times is different when connected over LAN.



But when not using cache it took 3 minutes and 54 secoonds to open the connector.



With cache it took 5 seconds.

[TimF]

thanks - this has helped, but I'm not sure if it will be enough. I'm down from 14 minutes to 5 minutes from the cache (the cache is >7Mb).



I'm hoping there might be a way to reduce the amount of info it stores in the cache. It seems to store all table definitions, whereas I could quite easily specify a small subset of tables that I need.



Tim

[tommy]

The .cch file that has been generated is in XML format.



I don't know if it will work but you *could* edit that to only include what you need.



Otherwise I suggest you ask Peregrine to open an enhancement request on this. Other users must have same issue.

[TimF]

thanks again - editing the cache file works great - now need to check if this is supported!