GeniusConnect support forum
GeniusConnect support forum
Home | Profile | Register | Active Topics | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 GeniusConnect
 FAQ
 Primary Key Storage: Outlook versus File
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Admin

Czech Republic
1677 Posts

Posted - 24 Jan 2012 :  23:54:53  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
GeniusConnect stores information about record primary key value in Outlook item or (from version 5.0.0.7) in a file.


Outlook item storage (default setting):
GeniusConnect will create custom fields (MAPI user-defined fields) inside Outlook items to store database record primary key value.

Pro
less maintenance/no external files
Con
Performance decrease on MS Exchange
Possible problems on MS Exchange with Outlook cached mode

File storage:
GeniusConnect will store database record primary key value in a file outside Outlook.

Pro
Better performance on MS Exchange
No problems on MS Exchange with Outlook cached mode
Con
more maintenance/external files must be included in regular backup!

How To...
Assign Table->Options->Advanced->Primary Key storage
When changed for existing folder mapping, GeniusConnect will activate conversion automatically after closing Assign Table dialog.

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

Change default storage(does not change existing folder configuration, only default values for new table assignments):
GeniusConnect->Database->Right Click any folder->Primary key storage defaults...

File storage support from GeniusConnect 5.0.0.7

Screen shots:


Convert storage:
Menu:

Dialog:




Set Default Storage:
Menu:

Dialog:




Admin

Czech Republic
1677 Posts

Posted - 26 Feb 2015 :  00:16:44  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
File storage: primary key file(s) should be included in regular backup!
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
GeniusConnect support forum © Copyright (C) 2003 - 2019, GeniusConnect, All Rights Reserved. Go To Top Of Page
Snitz Forums 2000