11/29/2024 6:28:08 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.
|
|
|
|
Will Attachments Eventually Affect Performance?
Posted: 28 Sep 09 2:37 PM
|
One of our Salesmen said that (years ago) he was told that if we attach too many files in SLX, that it will really slow down the performance of SLX.
How true is that?
What does it actually affect? -- just the one account that has a lot of attachments or the whole system?
Is there anything we can do (besides disallowing attachments) to alleviate that (if it is even true)? |
|
|
|
Re: Will Attachments Eventually Affect Performance?
Posted: 29 Sep 09 3:40 AM
|
| It's not true - the files are held outside of the database - not within. Therefore, you can have as many as your disk allows ! However, each file does get sent via sync (unless you're not using sync and therefore no issue) so there's a potential downside to sync as it needs to send them - but it chunks them into parts and, unless your users attach massive ppt's - you shouldn't have any issues. |
|
|
|
Re: Will Attachments Eventually Affect Performance?
Posted: 21 Oct 09 3:53 AM
|
As with anything, the answer is it varies.
The attachemnts don't get added to the Database, so they don't affect the Performance of SQL Server, they are stored on a File Server (or for Remote locally).
If you take into accounts Remote users, if they truly have a large amount of Attachments, you could always run into issues with local storage (e.g. Corrupted Files, Indexing, Defragmentation, etc).
Also, as stated by others, the Files need to be synchronized up and/or down from the Server as changes are made.
Finally, and this may be the source of the rumor, if you cut someone a new database and check the option to Send them Attachments, their synchronization process will get bogged down for several days all applicable attachment files are sent to the remotes. |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|