On Jul 10, 2009, at 5:25 PM, "workerho...@studysite.eu" > wrote:
first thanks to all who have read ;-)
your solution looks like the method how i done it actually,
i have tested the last hours the solution with sql lite on
application server
the Solution:
3 Mysql Server ( 1 more to han
first thanks to all who have read ;-)
your solution looks like the method how i done it actually,
i have tested the last hours the solution with sql lite on application
server
the Solution:
3 Mysql Server ( 1 more to handle the big load ) (1 Master, 2 Slaves)
mysql replication
10 Applikatio
workerho...@studysite.eu wrote:
hi andrew i think you understand my problem a little,
but if 100 user load this query at the same time, the two mysql server
had a lot to do!
so i think to cache this query as xml to the application server local
make thinks faster,
but, i would like to have the s
On Fri, 10 Jul 2009 13:29:31 -0400
Bastien Koert wrote:
> On Fri, Jul 10, 2009 at 1:23 PM,
> workerho...@studysite.eu wrote:
> > hmm, the infrastructure ist good, this is just this query
> > so to solve my problem i could run mysql on the application server
> > and store just this table
> > a
yes i think i should do this
Daniel Brown schrieb:
On Fri, Jul 10, 2009 at 13:23,
workerho...@studysite.eu wrote:
hmm, the infrastructure ist good, this is just this query
so to solve my problem i could run mysql on the application server and store
just this table
and read the query
On Fri, Jul 10, 2009 at 1:23 PM,
workerho...@studysite.eu wrote:
> hmm, the infrastructure ist good, this is just this query
> so to solve my problem i could run mysql on the application server and store
> just this table
> and read the query from them, it could solve my problem litte, i hope s
On Fri, Jul 10, 2009 at 13:23,
workerho...@studysite.eu wrote:
> hmm, the infrastructure ist good, this is just this query
> so to solve my problem i could run mysql on the application server and store
> just this table
> and read the query from them, it could solve my problem litte, i hope so!
hmm, the infrastructure ist good, this is just this query
so to solve my problem i could run mysql on the application server and
store just this table
and read the query from them, it could solve my problem litte, i hope so!
Daniel Brown schrieb:
On Fri, Jul 10, 2009 at 13:07,
workerho..
On Fri, Jul 10, 2009 at 13:07,
workerho...@studysite.eu wrote:
> hi andrew i think you understand my problem a little,
> but if 100 user load this query at the same time, the two mysql server had a
> lot to do!
> so i think to cache this query as xml to the application server local make
> thinks fa
On Fri, Jul 10, 2009 at 12:59, Andrew Ballard wrote:
>
> I understood the question to be how to improve performance by caching
> MySQL results into an XML document (which, given that it was posted
> here) within a PHP script. Perhaps this is not the correct
> interpretation, but if so it would be r
hi andrew i think you understand my problem a little,
but if 100 user load this query at the same time, the two mysql server
had a lot to do!
so i think to cache this query as xml to the application server local
make thinks faster,
but, i would like to have the same performance to read this xml
On Fri, Jul 10, 2009 at 12:36 PM, Daniel Brown wrote:
> Chris;
>
> From my understanding of your question, your message (included
> below in its entirety) is better sent to the MySQL General list, which
> I've CC'd on this reply. If you haven't yet, please subscribe there
> at mysql-subscr..
Chris;
From my understanding of your question, your message (included
below in its entirety) is better sent to the MySQL General list, which
I've CC'd on this reply. If you haven't yet, please subscribe there
at mysql-subscr...@lists.mysql.com to follow the thread for responses.
If I
hi guys, i need some help by optimize the performance.
my problem is that i need a lot of rows the whole site (don't ask i need
the rows really :-) )
this is about ~4000 rows it will be loaded from mysql database in 0.3
seconds
my idea was to cache this rows in a xml file like for example:
14 matches
Mail list logo