Show real time data to users with same response time

I've doubt regarding speed and latency for show real time data.

Let's assume that I want to show read time data to users by fire ajax requests at every second that get data from MySql table by simple collection query.

For that currently these two options are bubbling in my mind

  1. MySql / Amazon Aurora
  2. File system

Among these options which would be better? Or any other solution?

As I checked practically, if we open one page in browser then ajax requests gives response in less than 500ms using PHP, MySql, Nginx stack.

But if we open more pages then same ajax requests gives response in more than 1 second that should be less than 500ms for every visitors.

So in this case if visitors increase then ajax requests gives very poor response.

I also checked with Node.js+MySql but same result.

Is it good to create json files for records and fetch data from file? Or any other solution?


Category: mysql 5.6 Time: 2016-07-28 Views: 0

Related post

  • Why are there two users with same name? 2013-02-04

    When I execute users command, it output two users with same name. Why are there two users? I'm pretty sure that I created just one user. i.e [email protected]:~$ users gives following output username username --------------Solutions------------- The

  • Create View to display users with same select list value to each individual user 2014-10-02

    When a user registers on my site, he/she chooses the college he attended and the course he/she studied from select list fields i created using the profile 2 module Is there a way to create a View that displays to each user the people who attended the

  • Retrieve password only by login. Users with same email 2014-10-27

    First: Which lines I should comment in wp-login.php that user can retrieve password only by login (without email)? Second: I want try do possible register users with same email. It is possible with that solution?

  • How can I force logout of other users with same username 2015-11-12

    On user login I need to kick all users with same username except for the current one, thus automatically log him out from other ttys. I know that one can kick other users via slain, but not much more. Example: user1 logs in via session1 => everyone w

  • Showing two users with same account name in same domain and same computer 2015-11-21

    I am new to active-directory. my server domain name is 'VIANOVA', and there is a user 'edith'. I think I have made some changes in 'last name' of user account properties in Active-directory, now i am getting a fresh desktop when i have logged in and

  • How to show the array data in textview with Tag and how to add more tag with search Functionality in user list in ios 2016-01-21

    I'm stuck when View Load first time i want to show some array data with tag.And after this i want to add another tag like more than one. I'm using Third party: TITokenField NSArray * names=ary_ContactDetail; TIToken * token=[_tokenFieldView.tokenFiel

  • Two users with same name but different passwords 2013-05-29

    Is it possible to create two users with the same name, and let LightDM choose between them at login if one of the passwords is given? For example, to anyone opening my computer, it would seem like there is only one user. If he would enter the right p

  • Querying Email Addresses for a List of Users with Same Last Name? 2011-04-23

    I have a site with many users and many of them have the same last name. I want to get the emails of all the users with the same last name (IE: Smith) that has a post related to a particular taxonomy term (IE: Baseball). So far I have this code that w

  • Need to manually add multiple WP users with same e-mail address (with good reason) 2016-01-25

    For starters, I'm aware of the concerns generally brought up by many when someone looks for a way to skip duplicate e-mail checks for creating new user accounts. However, In my case, I believe the reason for needing this is justified if I can explain

  • User with same permission not getting similar search result as other user in sharepoint 2007 2016-01-29

    I am having an issue where a user is not getting exactly the same search result as other users in the team. The user joined the team recently and I granted permission through adding her into a Sharepoint Group. In practical sharepoint wont show list/

  • changing scheduled task user with same rights gives error result 2012-10-04

    We are successfully running scheduled tasks on a windows 2003 server. The tasks are all executed batch files that are physically on a different server on the network. We use a domain admin user (so full rights) to run the tasks and to log on to serve

  • Send email to users with same field value in a select list 2014-10-31

    When a user registers on my site he/she chooses his/her State of Origin. Using Rules I would like to configure a rule which sends an email to all users from the same state when a user from that state edits his/her profile. Please is this possible usi

  • Finding two users with same pair group 2015-07-27

    I have the following table which details actions of users and the action's parameters: action_id(auto-increment) | user_id | action_name | action_attr1 I want to find which users performed the same actions exactly with same action_attr1. Meaning, I w

  • how to prevent access to other user with same user id (UID) 2015-10-14

    I have two Linux OS installed in two partitions in my system. However I have few usernames which are common in both partitions. For ex, I have user friend in both the OS. I have noticed that friend in one OS has access to the files of friend in other

  • don't allow multiple users with same email 2015-12-14

    I've got a site using Commerce. On checkout a user is created to allow access to files, order history etc. I just had a customer that couldn't find his files and discovered that he had two accounts registered to the same email address. So it seems my

  • Samba AD user with same name as local user 2016-01-18

    I just started using Samba as a domain controller at home. I have set up so that users who log on to the server have users and home folders created if it's the first time etc. I have one issue though. I had a local user on the linux server with my co

  • LDAP: Local and remote user with same username 2014-11-05

    I have configured an openLDAP server with LDAP user and group ids beginning at 10000. My client successfully binds to the LDAP server via ldapsearch. Additionally, getent passwd|group returns a full list of local and remote (LDAP) users|groups. My lo

  • How to show "Last edited" date and user on Google Sheets? 2015-02-03

    I've got a Google sheet that is updated quite regularly by a few people. I'd like to be able to view the doc, and at a glance-have a cell that shows a date (last modified) and another cell (user that made the modification). Is this at all possible an

  • Multiple rdp users with same instance of chrome (or mozilla) 2016-01-17

    Scenario: Windows server 2008 with multiple rdp sessions enabled, and multiple users logged in. user1 logs in via rdp on server, opens google chrome, logs into a (specific) website user2 logs in via rdp on server, opens google chrome, logs into a (sa

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development


Front-end development


development tools

Open Platform

Javascript development

.NET development

cloud computing


Copyright (C), All Rights Reserved.

processed in 2.201 (s). 13 q(s)