Alpha DevCon 2018
Results 1 to 30 of 30

Thread: Real-life WAS/SQL

  1. #1
    "Certified" Alphaholic chadbrown's Avatar
    Real Name
    Chad Brown
    Join Date
    Aug 2007
    Location
    Aurora, Ontario, Canada
    Posts
    1,395

    Default Real-life WAS/SQL

    Hi just wanted to post some real-life numbers of both WAS and MySQL The following are numbers for concurrent users and some table facts hopefully this can shed some light for programmers wondering how WAS and MySQL do.

    I have 2 servers with zebrahost each running 1 WAS and the Server1 runs mysql 5.5 64bit

    Server 1 8 cores 4 gb ram 41 concurrent users
    Server 2 2 cores 2 gb ram 29 concurrent users

    Have completed 55000 invoices since july 1st 2010
    Average 300 user logins per day.

    Both of the concurrent user numbers are from today and I have not noticed any lag whatsoever on either machine.
    Chad Brown

  2. #2
    "Certified" Alphaholic chadbrown's Avatar
    Real Name
    Chad Brown
    Join Date
    Aug 2007
    Location
    Aurora, Ontario, Canada
    Posts
    1,395

    Default Re: Real-life WAS/SQL

    Just got to 47 on server1
    Chad Brown

  3. #3
    "Certified" Alphaholic peteconway's Avatar
    Real Name
    Peter Conway
    Join Date
    Oct 2005
    Location
    Melbourne, Australia
    Posts
    2,484

    Default Re: Real-life WAS/SQL

    That's great info mate and - really well done - good on you!
    Insanity: doing the same thing over and over again and expecting different results.
    Albert Einstein, (attributed)
    US (German-born) physicist (1879 - 1955)

  4. #4
    Moderator Peter.Greulich's Avatar
    Real Name
    Peter Greulich
    Join Date
    Apr 2000
    Location
    Boston, MA
    Posts
    11,545

    Default Re: Real-life WAS/SQL

    Quote Originally Posted by chadbrown View Post
    Just got to 47 on server1
    But how many instances of the WAS?

  5. #5
    "Certified" Alphaholic chadbrown's Avatar
    Real Name
    Chad Brown
    Join Date
    Aug 2007
    Location
    Aurora, Ontario, Canada
    Posts
    1,395

    Default Re: Real-life WAS/SQL

    Just one Peter and it looks like I have peaked at 58 for today on Server1.
    Mondays are purchase order days and always one of my busier ones.
    Chad Brown

  6. #6
    Moderator Steve Wood's Avatar
    Real Name
    Steve Wood
    Join Date
    Nov 2003
    Location
    Bay Area, California
    Posts
    8,787

    Default Re: Real-life WAS/SQL

    Exactly what method are you using to count "concurrent users"? And what do you mean by concurrent?
    Steve Wood
    Join the ALPHA DEVELOPERS NETWORK
    There is no Cloud. It's just someone else's computer.
    Web - Mobile - Hosting - Products - Frameworks - Developer Resources
    AlphaToGo | IADN (100% Alpha Anywhere Websites)

  7. #7
    "Certified" Alphaholic chadbrown's Avatar
    Real Name
    Chad Brown
    Join Date
    Aug 2007
    Location
    Aurora, Ontario, Canada
    Posts
    1,395

    Default Re: Real-life WAS/SQL

    Hi Steve, I am using Server.SessionCount which from what I understand is a session folder count. I guess the only problem with that is that if a user has closed the browser until that session ie folder times out it would be over inflated. For the most part today it floated on average 40-45 as a sessioncount on the primary server and about 22 for the smaller server.
    Another interesting fact is how low the ram use is for WAS which is around 165MB.
    Also I do run WAS security on mysql.
    Chad Brown

  8. #8
    Member koga101's Avatar
    Real Name
    Chris O'Brien
    Join Date
    Mar 2009
    Location
    Los Angeles, CA
    Posts
    105

    Default Re: Real-life WAS/SQL

    Hi Chad,

    This is a large project. Did you consider cloud hosting, and if so, why did you decide to go with your own servers?

    I am also working on an enterprise app and considering such options for cost savings and getting the most out of WAS licenses.

  9. #9
    "Certified" Alphaholic chadbrown's Avatar
    Real Name
    Chad Brown
    Join Date
    Aug 2007
    Location
    Aurora, Ontario, Canada
    Posts
    1,395

    Default Re: Real-life WAS/SQL

    Chris, I didn't consider going to cloud type hosting. The two servers that I have at Zebrahost are reasonable I believe. Maybe in the future I would consider it. I have a customer that has expressed great interest in going with my software, they are about 5 times the current volume of users that I have on my two servers now. I will need to find a bigger solution for serving if in fact they do go with my software.
    Chad Brown

  10. #10
    Moderator Steve Wood's Avatar
    Real Name
    Steve Wood
    Join Date
    Nov 2003
    Location
    Bay Area, California
    Posts
    8,787

    Default Re: Real-life WAS/SQL

    I am using Server.SessionCount which from what I understand is a session folder count. I guess the only problem with that is that if a user has closed the browser until that session ie folder times out it would be over inflated.
    I agree, it does not mean concurrent users because each browser instance creates a session count, and that count stays resident until the session expires, so they overlap, even if they log off. Relying only on this figure, you could just as easily have just one user at a time. A better way to track concurrent useage it to pick one two prime transactions and log them, look for multiple transactions in a given time period.
    Steve Wood
    Join the ALPHA DEVELOPERS NETWORK
    There is no Cloud. It's just someone else's computer.
    Web - Mobile - Hosting - Products - Frameworks - Developer Resources
    AlphaToGo | IADN (100% Alpha Anywhere Websites)

  11. #11
    "Certified" Alphaholic chadbrown's Avatar
    Real Name
    Chad Brown
    Join Date
    Aug 2007
    Location
    Aurora, Ontario, Canada
    Posts
    1,395

    Default Re: Real-life WAS/SQL

    Steve, I do keep a log of all logins which track all userid's and other items such as what server was logged into, time and other items. During a time frame of 30 min period I did have 43 unique employees log into the server1.

    Below are a some stats from mysql as you can see the server is taking a query at a rate of almost one per second.

    Open_files 34
    Open_streams 0
    Open_tables 179
    Opened_tables 469
    Questions 1699534
    Uptime in seconds 1813114
    Chad Brown

  12. #12
    Moderator Steve Wood's Avatar
    Real Name
    Steve Wood
    Join Date
    Nov 2003
    Location
    Bay Area, California
    Posts
    8,787

    Default Re: Real-life WAS/SQL

    Your scenario is probably more realistic than some of the empirical test some of us have been running -- "Lots of users over a brief period of time". As long as there is a second or two between individual or the blocks of concurrent users don't exceed some maximum, the server peforms well.
    Steve Wood
    Join the ALPHA DEVELOPERS NETWORK
    There is no Cloud. It's just someone else's computer.
    Web - Mobile - Hosting - Products - Frameworks - Developer Resources
    AlphaToGo | IADN (100% Alpha Anywhere Websites)

  13. #13
    "Certified" Alphaholic chadbrown's Avatar
    Real Name
    Chad Brown
    Join Date
    Aug 2007
    Location
    Aurora, Ontario, Canada
    Posts
    1,395

    Default Re: Real-life WAS/SQL

    I guess concurrent users is a hard thing to prove and maybe I was using the wrong terminology but I was not trying to miss-lead in any way.

    I am not sure how you could ever figure out true concurrent users being that you don't have to submit anything to be a user. You could be a user that only looks at read only grids, or view and print reports.
    Chad Brown

  14. #14
    Moderator Steve Wood's Avatar
    Real Name
    Steve Wood
    Join Date
    Nov 2003
    Location
    Bay Area, California
    Posts
    8,787

    Default Re: Real-life WAS/SQL

    Yeah, I don't really know either. The important thing, and I didn't mean to take it away from you, is you have a successful obviously well-built operation running smooth, and that is a very, very cool and congratulations!
    Steve Wood
    Join the ALPHA DEVELOPERS NETWORK
    There is no Cloud. It's just someone else's computer.
    Web - Mobile - Hosting - Products - Frameworks - Developer Resources
    AlphaToGo | IADN (100% Alpha Anywhere Websites)

  15. #15
    "Certified" Alphaholic kkfin's Avatar
    Real Name
    Kenneth
    Join Date
    Dec 2006
    Location
    EU
    Posts
    1,387

    Default Re: Real-life WAS/SQL

    Quote Originally Posted by koga101 View Post
    This is a large project. Did you consider cloud hosting, and if so, why did you decide to go with your own servers?
    Lets calculate the cost of three separate servers in Amazon Cloud:

    In Amazon cloud:

    For Mysql: Standard Reserved instance small(linux) cost: 0,03 * 24 * 30= 21,60 + 9,72(350/3/12) = 31,32 per month.

    For Alpha Was Server 1 High-CPU Reserved Instances Medium (Win2800 64 or 32) cost: 0,125*24*30= 90 + 19,44 (700/3/12)= 109,44 per month

    For Alpha Was Server 2 High-CPU Reserved Instances Medium (Win2800 64 or 32) cost: 0,125*24*30= 90 + 19,44 (700/3/12)= 109,44 per month

    For S3(hard disks) about 30,00 per month.

    So in Amazon cloud three separate servers cost is 31,32 + 109,44 + 109,44 + 30= 280,20/month.( And if you are living in euro world then the cost is 280,2 * 0,75= 210,15 euros per month for three separate Amazon Cloud servers)

    And if you shutdown other Alpha server for example between 10pm to 6am = 8 hours per day you have possibility to save 0,125*8*30= 30,00 per month. Then cost is 280,20-30,00 = 250,20 per month.

  16. #16
    "Certified" Alphaholic
    Real Name
    Frank Bicknell
    Join Date
    Feb 2010
    Location
    39.1915° N, 84.4348° W
    Posts
    2,441

    Default Re: Real-life WAS/SQL

    All of you thinking about using the 'cloud' pay heed to what just happened at Google, the cloud just 'evaporated'.

  17. #17
    "Certified" Alphaholic NoeticCC's Avatar
    Real Name
    Andrea Gill
    Join Date
    Nov 2007
    Location
    Golcar, West Yorkshire, UK
    Posts
    2,064

    Default Re: Real-life WAS/SQL

    We had all of BMJ's articles picked up from an Alpha5 server with each page view retrieving a file from our file system and then displaying it in the browser. We also had all their online only "Case Reports" previewed by converting an XML file into HTML and inserting all the images as thumbnails, converting links and references appropriately etc.

    Not a lot of logged in users but dozens of people accessing the files every hour.

  18. #18
    "Certified" Alphaholic
    Real Name
    Frank Bicknell
    Join Date
    Feb 2010
    Location
    39.1915° N, 84.4348° W
    Posts
    2,441

    Default Re: Real-life WAS/SQL

    Quote Originally Posted by chadbrown View Post
    I guess concurrent users is a hard thing to prove and maybe I was using the wrong terminology but I was not trying to miss-lead in any way.

    I am not sure how you could ever figure out true concurrent users being that you don't have to submit anything to be a user. You could be a user that only looks at read only grids, or view and print reports.
    There is a neat utility called CurrPorts http://www.nirsoft.net/utils/cports.html
    It will give you an instant picture of all ports on your server.
    It is customizable and you can create logs so I think you could get an true count of connections. This monitors actual connections to the port so it won't care about sessions. If you use it and like it please donate.

  19. #19
    Member NicholasWieland's Avatar
    Real Name
    Nicholas Wieland
    Join Date
    Apr 2008
    Location
    Huntington, NY
    Posts
    545

    Default Re: Real-life WAS/SQL

    Quote Originally Posted by frankbicknell View Post
    All of you thinking about using the 'cloud' pay heed to what just happened at Google, the cloud just 'evaporated'.
    What does that mean?:confused:
    Nicholas Wieland
    LedgerSuite.com Corp
    nnw@edfi.net
    http://www.ledgersuite.com


  20. #20
    "Certified" Alphaholic chadbrown's Avatar
    Real Name
    Chad Brown
    Join Date
    Aug 2007
    Location
    Aurora, Ontario, Canada
    Posts
    1,395

    Default Re: Real-life WAS/SQL

    Supposedly there was a period of time when anyone using the google docs which are in the clouds had no access to there files. A scary notion!
    Chad Brown

  21. #21
    Moderator Peter.Greulich's Avatar
    Real Name
    Peter Greulich
    Join Date
    Apr 2000
    Location
    Boston, MA
    Posts
    11,545

    Default Re: Real-life WAS/SQL

    Supposedly there was a period of time when anyone using the google docs which are in the clouds had no access to there files.
    To a small % of users.

  22. #22
    Member
    Real Name
    Wendy Welton
    Join Date
    Feb 2011
    Location
    Hampton & North Hampton NH
    Posts
    809

    Default Re: Real-life WAS/SQL

    Peter & Steve,

    If I'm freaking out at least a little bit about this concurrent users thing, am I getting my knickers in knots about nothing?
    Wendy Welton
    Architect
    past & future Alphaholic - deliberately falling off the wagon!

    http://www.artformhomeplans.com/

  23. #23
    Moderator Peter.Greulich's Avatar
    Real Name
    Peter Greulich
    Join Date
    Apr 2000
    Location
    Boston, MA
    Posts
    11,545

    Default Re: Real-life WAS/SQL

    Take a deep breath. :) You're getting ahead of yourself a little.

  24. #24
    Member
    Real Name
    Wendy Welton
    Join Date
    Feb 2011
    Location
    Hampton & North Hampton NH
    Posts
    809

    Default Re: Real-life WAS/SQL

    Sorry - this system hichupped and duplicated my post - and I don't see a way to delete. Ignore this one.
    Thanks.
    Wendy Welton
    Architect
    past & future Alphaholic - deliberately falling off the wagon!

    http://www.artformhomeplans.com/

  25. #25
    Member
    Real Name
    Wendy Welton
    Join Date
    Feb 2011
    Location
    Hampton & North Hampton NH
    Posts
    809

    Default Re: Real-life WAS/SQL

    Peter,

    I'm tryin' to! (Breathe, that is. Breathing is good.)

    I'm actually less worried about problems right out of the gate as I am about problems when all my grand plans are both in place and actually produce results! Hitting that wall would be a sign of success.

    Thanks.
    Wendy Welton
    Architect
    past & future Alphaholic - deliberately falling off the wagon!

    http://www.artformhomeplans.com/

  26. #26
    VAR Pat Bremkamp's Avatar
    Real Name
    Pat Bremkamp
    Join Date
    Apr 2000
    Location
    Oregon, USA
    Posts
    2,575

    Default Re: Real-life WAS/SQL

    Re concurrent users...

    In Chad's case, he knows how many concurrent users there are because they are employees in his stores. This is not theory. He knows the number of computers and the number of users and how long it takes to process a customer activation and create invoices, purchase orders and accounting reconcilliations.

    Much different that my looking at visitors to my public site when I don't know how many, where they are or what they are doing.

    So, I think his title of Real-life is pretty accurate.

    Pat
    Pat Bremkamp
    MindKicks Consulting

  27. #27
    "Certified" Alphaholic
    Real Name
    Frank Bicknell
    Join Date
    Feb 2010
    Location
    39.1915° N, 84.4348° W
    Posts
    2,441

    Default Re: Real-life WAS/SQL

    Quote Originally Posted by WendyWelton View Post
    Peter & Steve,

    If I'm freaking out at least a little bit about this concurrent users thing, am I getting my knickers in knots about nothing?
    Wendy,

    There really is no limit to the number of concurrent users. It is a matter of CPU power and bandwidth, both of which can be increased. It is really a matter of money.

  28. #28
    "Certified" Alphaholic chadbrown's Avatar
    Real Name
    Chad Brown
    Join Date
    Aug 2007
    Location
    Aurora, Ontario, Canada
    Posts
    1,395

    Default Re: Real-life WAS/SQL

    Quote Originally Posted by frankbicknell View Post
    Wendy,

    There really is no limit to the number of concurrent users. It is a matter of CPU power and bandwidth, both of which can be increased. It is really a matter of money.

    Easy with the no limit there Frank. Wendy is probably referring to one WAS.

    I do agree you can scale it up quite a bit if you want to with multiple servers and instances of WAS but you better not be using dbf if you want some large number of users.
    Chad Brown

  29. #29
    Member
    Real Name
    Wendy Welton
    Join Date
    Feb 2011
    Location
    Hampton & North Hampton NH
    Posts
    809

    Default Re: Real-life WAS/SQL

    Thanks guys.

    Yes, I was talking about one WAS, but I accidentally bought two (long story, short life!) - so I guess I could use both.

    On advice from Peter (my tutor) and Steve (I'm using his framework) - I'm going to just proceed for now, still dbf and all. I switch to SQL at some point in the future, but we're on a roll and there's some urgency to getting my current web site replaced - at least a "beta" version of it on a alternate domain address for my subscription builders.

    Pat's point is, imho, spot on. A web site that's the public face of a business is a completely different animal than a web site that's heavy on data entry and data processing. Potentially a lot more users - but potentially less intensive as the database sees it.

    That's why I would still be interested in any links to active websites and some basic stats to go with them (how many visitors per day, how many pages they visit) along with basic setup (1 WAS, 2...) and any other tidbits that pertain.

    I'm officially done "freaking out" and moving on to absorbing information so I can keep mentally planning as I grow my current web site and user base, and plan add-on web sites.

    And thank you IMMENSELY to everyone who took the time to patiently 'plain me this!
    Wendy Welton
    Architect
    past & future Alphaholic - deliberately falling off the wagon!

    http://www.artformhomeplans.com/

  30. #30
    Member
    Real Name
    Wendy Welton
    Join Date
    Feb 2011
    Location
    Hampton & North Hampton NH
    Posts
    809

    Default Re: Real-life WAS/SQL

    One last thought. I think "concurrent actions" might be a more accurate and less scary way to phrase it.
    Wendy Welton
    Architect
    past & future Alphaholic - deliberately falling off the wagon!

    http://www.artformhomeplans.com/

Similar Threads

  1. Web server hooked up to SQL database real slow
    By Atta in forum Application Server Version 9 - Web/Browser Applications
    Replies: 2
    Last Post: 11-19-2008, 05:37 PM
  2. Templates for life insurance brokerage
    By paul5555 in forum Database Design
    Replies: 0
    Last Post: 01-15-2008, 02:48 PM
  3. Limiting program life to 12 months
    By Taran Scott in forum Alpha Five Version 5
    Replies: 13
    Last Post: 03-19-2004, 04:54 AM
  4. Win 98 Life Extended 1 Week
    By George Pelkofer in forum Alpha Five Version 5
    Replies: 2
    Last Post: 12-10-2003, 06:57 AM
  5. LIFE LINE REQUEST
    By Coyndigger in forum Alpha Five Version 4
    Replies: 5
    Last Post: 09-16-2000, 05:04 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •