New topic: Performance
<http://forums.realsoftware.com/viewtopic.php?t=46282> Page 1 of 1 [ 2 posts ] Previous topic | Next topic Author Message george Post subject: PerformancePosted: Tue Dec 18, 2012 9:19 pm Joined: Mon Oct 09, 2006 3:20 pm Posts: 313 Realistically, with a typical (decent) VPS hosting setup, can an RSWEB database app handle a few thousand (lets say 2500-5000) simultaneous users? Furthermore, would it be ok to use a sqlite database file for each user, or should a database server be used instead? Top taylor-design Post subject: Re: PerformancePosted: Wed Dec 19, 2012 10:11 am Joined: Wed Mar 22, 2006 11:15 am Posts: 528 Location: Southern California Too many factors are involved to answer this conclusively. What does the app do? What does the typical user do? How much RAM does each session require? What are the SQL queries like? How much disk I/O? How many resources are allocated to the VPS? CGI or stand alone? Gut reaction: I would recommend a dedicated server to a client with this many simultaneous users. In fact, I would probably recommend at least two, one for WE and one for SQL. I would definitely go with Postgres or MySQL. And I would design the WE app with scaling (i.e. multiple WE servers) in mind. _________________ Daniel L. Taylor Custom Controls for Real Studio WE! Visit: http://www.webcustomcontrols.com/ Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 2 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
