Welcome to the Calyx Software Message Boards where you can share ideas and solutions with other Calyx users! Calyx personnel including Tech Support, Development, QA, and Business Planning often visit these message boards unofficially to better understand our customers' needs. To submit your suggestions Click Here.
This discussion forum is a service provided by Calyx Software. Calyx Software does not endorse any particular point of view expressed in this forum or any information provided in it. The use of the information provided by other users in this message board is at your own risk.
Calyx Software Message Board
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      


««12

PDS Using SQL Express vs SQLExpand / Collapse
Author
Message
Posted 8/6/2008 2:41:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 10/24/2008 12:06:00 PM
Posts: 8, Visits: 15
Tell that "Tech Team" to go blow themselves. Im a Network Admin, in charge of a clients PDS theyve been using PDS with SQL Express 4GB RAM system (even though SQL Express only uses 1GB of that at most) it allows the servers load to have plenty of legroom. There are approx 50 users here all with Point installed on their local workstation strung across various sites 4-5 locations) who access the PDS server at the main office along with local users at the main office. We've been running Point since 5.4 and have loans from 2003-200x (Im not onsite to tell you the total sizes) but with your numbers Im sure your well within range.

Full SQL Server is not needed at that small a level. If your talking 500+ loans a month over 100 users or more then maybe you could consider it but even then I doubt it. Point doesnt place that great a strain on SQL that its required. If Point used SQL properly there would be less problems involved than they have just using it as more a index/query (but thats another issue.)

PDS is accessed via the local point install over HTTPS a secure web socket connection so as long as there is an internet connection running users everwhere will be able to access it. My question would be why do you want to use a Terminal Service connection to run point? Just have those users install a local workstation copy of point and be done with it (This will also put less strain on both start and end points internet bandwidth, since you must make that connection from one computer to the server (creates 2 loads essentially that arent needed).
Post #7085
« Prev Topic | Next Topic »

««12

Reading This TopicExpand / Collapse
Active Users: 1 (1 guest, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Emmanuel Huna, Bryan Telford, Jason Beck, Mike Thompson, BetaFisch

PermissionsExpand / Collapse

All times are GMT -8:00, Time now is 9:23pm

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.016. 11 queries. Compression Enabled.
© 2005 Calyx Software. All rights reserved.