Fortunately you can configure MySql as good as you need, and it seems to have internal systems of caching data, so, I think that aren't 400 real queries per second.
You can answer yourself opening something like phpMyAdmin and try to do the query by the SQL tab and take a look at ' in how many time the query is executed '. I don't know why you need to do that thing in this way but it seems 'not-so-ideal' for me. Can you give us more information? Marco Inviato da iPhone Il giorno 24/feb/2011, alle ore 04:43, Summer nguyen <[email protected]> ha scritto: > Hello, > The table has about less than 50 records. > And the query like : SELECT a,b,c,d FROM test_table WHERE id = 123 LIMIT 1 > > I have 200 clients ( now increasing) online at a moment who have to get > infomation every 500 miliseconds. > So Server.js have to do more than 400 queries every seconds. > Do you think mysql can handle ? > > And btw, I have a problem with my code. I dont understand why the code > doesn't work. > I try to alert before APE works, alert OK. But after client.load(), alert > not OK. > Here is the code. please help me. Thank you very much. > > On Wed, Feb 23, 2011 at 10:02 PM, Marco Orlandin <[email protected]> wrote: > Sincerely how much complex is the query? > > MySQL can handle a "LOT" of query is tables are good indexed... > > On Wed, Feb 23, 2011 at 10:57 AM, Summer nguyen <[email protected]> > wrote: > > Dear all, > > I have many data store in mysql database , and it's updated every second. > > So I want to use APE Server.js to get infomation and broadcast to Clients > > every 500 miliseconds. > > I have many clients , so I am afraid that mysql can not handle hundreads of > > query per second, and every second. > > I have an idea to use JAVA to write infomation to a XML file, then I use > > server.js to get infomation from this XML file. > > I am finding a solution to use server.js to get infomation from XML file. > > anyone know, please help me. Thank you very much. > > > > -- > > You received this message because you are subscribed to the Google > > Groups "APE Project" group. > > To post to this group, send email to [email protected] > > To unsubscribe from this group, send email to > > [email protected] > > For more options, visit this group at > > http://groups.google.com/group/ape-project?hl=en > > --- > > APE Project (Ajax Push Engine) > > Official website : http://www.ape-project.org/ > > Git Hub : http://github.com/APE-Project/ > > > > > > -- > while ( ! ( succeed = try() ) ); > > -- > You received this message because you are subscribed to the Google > Groups "APE Project" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/ape-project?hl=en > --- > APE Project (Ajax Push Engine) > Official website : http://www.ape-project.org/ > Git Hub : http://github.com/APE-Project/ > > -- > You received this message because you are subscribed to the Google > Groups "APE Project" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/ape-project?hl=en > --- > APE Project (Ajax Push Engine) > Official website : http://www.ape-project.org/ > Git Hub : http://github.com/APE-Project/ > <severside.txt> > <countdown.php> -- You received this message because you are subscribed to the Google Groups "APE Project" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/ape-project?hl=en --- APE Project (Ajax Push Engine) Official website : http://www.ape-project.org/ Git Hub : http://github.com/APE-Project/
