Dear ,
I think I can not use cache in mysql. because data is changed every second.
But I will try to configure mysql to do so.
Thank you very much.
Btw, I have a problem with code again.
I dont know why I can not recevice event load
client.addEvent('load', function() {
alert("loaded"); // not works
client.core.start({'name': new Date().getTime().toString()});
});
I dont know why. Please tell me Thank you very much.
Note: I can not use check Tool because configuration of ngnix , because java
dont understand POST/GET in Tool Check. But Real TIme chat works.
Do you know why ? thanks so much.
On Thu, Feb 24, 2011 at 1:04 PM, Marco "MiPnamic" Orlandin <
[email protected]> wrote:
> 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]>
> [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]>
>> [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]>
>> [email protected]
>> > To unsubscribe from this group, send email to
>> > <ape-project%[email protected]>
>> [email protected]
>> > For more options, visit this group at
>> > <http://groups.google.com/group/ape-project?hl=en>
>> http://groups.google.com/group/ape-project?hl=en
>> > ---
>> > APE Project (Ajax Push Engine)
>> > Official website : <http://www.ape-project.org/>
>> http://www.ape-project.org/
>> > Git Hub : <http://github.com/APE-Project/>
>> 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]>
>> [email protected]
>> To unsubscribe from this group, send email to
>> <ape-project%[email protected]>
>> [email protected]
>> For more options, visit this group at
>> <http://groups.google.com/group/ape-project?hl=en>
>> http://groups.google.com/group/ape-project?hl=en
>> ---
>> APE Project (Ajax Push Engine)
>> Official website : <http://www.ape-project.org/>
>> http://www.ape-project.org/
>> Git Hub : <http://github.com/APE-Project/>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]>
> [email protected]
> To unsubscribe from this group, send email to
> <[email protected]>
> [email protected]
> For more options, visit this group at
> <http://groups.google.com/group/ape-project?hl=en>
> http://groups.google.com/group/ape-project?hl=en
> ---
> APE Project (Ajax Push Engine)
> Official website : <http://www.ape-project.org/>
> http://www.ape-project.org/
> Git Hub : <http://github.com/APE-Project/>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/
>
--
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/
