We are using GeniusConnect for the past several years, but recently we noticed GeniusConnect’s initialized time is increasing, now it takes 15-20 mins on every run before it transfers the first email to the database.

We have the one-way transfer of emails from outlook to SQL server and configured to delete the emails after successful upload.

The Email Submission table (which stores emails from outlook) in MS SQL Server has grown to 700,000+ records. The inbox has less than 100 emails outstanding to transfer.

Is initialization taking 15-20 mins due to a large number of records in the Email Submission table MS SQL server? Is there any way to speed the initialization?

INFO:20211115 12:09:41 Folder: \xxxx\Inbox
INFO:20211115 12:09:41 Connecting to database: EmailSubmission
INFO:20211115 12:09:41 Connected to database
INFO:20211115 12:25:39 Using file storage:D:\GeniusConnect\Inbox1.gc
INFO:20211115 12:25:40 Creating attachments connection
INFO:20211115 12:25:40 Saving all Outlook items to database...
WARNING:20211115 12:25:40 "Delete after save" option is enabled!. Outlook Items will be deleted after save!
INFO:20211115 12:25:40 Preparing to save items

Hello,

I think it may be caused by huge primary keys file, in your case it is this file :
INFO:20211115 12:25:39 Using file storage:D:\GeniusConnect\Inbox1.gc


You can try to Clear Primary keys, more info: https://www.geniusconnect.com/WebHelp/ClearprimarykeyfromOutlookitems.html 


Please note I’m assuming your config will store the mail item to Db and delete it, it will never be moved back to the folder. In case you will move them back you can’t use this procedure, since GeniusConnect will than wrongly re-insert a duplicate record to your table.

I cleared the primary keys, It took 17 minutes to initialize the transfer. Please see the logs below.


INFO:20211116 07:33:59 Starting on Internal scheduler signal
INFO:20211116 07:33:59 Start-scheduled synchronization
INFO:20211116 07:33:59 Scheduled synchronization Folder:Inbox
INFO:20211116 07:33:59 Folder: \\xxxx
INFO:20211116 07:33:59 Connecting to database: xxxxx

INFO:20211116 07:33:59 Connected to database
INFO:20211116 07:50:01 Using file storage:D:\GeniusConnect\Inbox1.gc

Hello,

The “D:\GeniusConnect\Inbox.gc” D drive, is it a local drive ?

You can also try Convert the primary key file to Outlook storage, its not recommended for Exchange/Office 365 , but since you are deleting all emails after DB save, it may be Ok in your case.


Convert folders to another storage:
GeniusConnect->Database Tab->Right Click the folder->Convert Primary key storage...

Hi,

Thank you so much for the suggestion. After changing primary key storage to outlook. Emails immediately started storing to DB, there is no initial wait time.

Thanks again!