Re: large data transfer between 2 processes

And, I think you have to optimize your code ;-) and databases.



"Jerry Stuckle" <jstucklex@xxxxxxxxxxxxx> ???????/???????? ? ????????
?????????: news:tOGdnZUtjbRVBqTeRVn-gQ@xxxxxxxxxxxxxx
> pierre.bru@xxxxxxxxx wrote:
>> hi,
>>
>> fist the context: I have a web server which query a mySql database. but
>> as the number of parralel queries increase, the server slows down too
>> much.
>>
>> I got 2 ideas, one of which is to run N deamons which effectively
>> execute requests. the PHP uses message queuing(1) to queue queries
>> request to the daemons. but the answer may be quite large, larger than
>> messages the message queueing service can handle.
>>
>> I thought to open back a communication link between the current daemon
>> and the waiting PHP to tranfer/process the result, using the message
>> queueing service to send back info regarding the opened link.
>>
>> I thought to open a pipe between the current daemon and the PHP. is
>> this possible? and if so, how? if not, is an IP link to localhost be as
>> fast as a pipe?
>>
>> TIA,
>> Pierre.
>>
>> (1) http://www.phpfreaks.com/phpmanual/page/function.msg-get-queue.html
>>
>
> Pierre,
>
> How is that going to help you? You're just adding another layer to an
> already slow process.
>
> First of all you need to determine why the slowdown occurs. Is it lack of
> CPU cycles? Insufficient real memory? Disk access time? Insufficient
> buffers/cache? Or any of a number of other things.
>
> Once you determine *why* the slowdown occurs, you can work on that
> problem. It may be tuning parameters, a faster CPU, multiple physical
> disks, more memory, or even another machine to run your MySQL queries.
>
> But just trying things without understanding the cause of the slowdown is
> a very hit-and-miss way of "fixing" it.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex@xxxxxxxxxxxxx
> ==================


.

Relevant Pages

  • Re: Multi Site Hosting
    ... put it on another machine running windows web server 2003 and direct the ... > I would expect to use databases for content when i have things working ... > but i was thinking of having this on another machine running SQL MSDE ... >> to not use your SBS for web sites exposed to the internet and better to ...
    (microsoft.public.windows.server.sbs)
  • Re: Open Ports
    ... >Connection closed by foreign host. ... >Failure To Connect To Web Server ... different services: telnet, ftp, and http. ... The other daemon that I don't see, and should probably be running, is ...
    (comp.os.linux.security)
  • Re: Lisp user group culture
    ... pretty decent job interfacing with databases. ... The web server will handle encryption of traffic via SSL, but I need to encrypt data in the database, so a robust library for handling AES, SHA and other acronyms would be great. ... web app, ...
    (comp.lang.lisp)
  • large data transfer between 2 processes
    ... I have a web server which query a mySql database. ... as the number of parralel queries increase, ... and the waiting PHP to tranfer/process the result, ... I thought to open a pipe between the current daemon and the PHP. ...
    (comp.lang.php)
  • IIS Installation and Administrative Rights
    ... I maintain databases for a large department in my ... but that I would not be able to install and maintain IIS ... Does their claim sound true? ... full administrative rights to the IIS web server, ...
    (microsoft.public.inetserver.iis.security)