Thank you... Actually I tried running the same script locally (by the way, I am running all this on a dedicated Unix machine and not a web server as such) and the same problem repeated. I mean, its doing everything with the same degree of slowness...
What I'm trying to do is an adjacent row comparison and if they are different, I'm copying them onto a different table. The code goes something like this:
As you can observe, there are many queries and this is the only way I thought would work... Do you think because I'm trying to say "SELECT * FROM trace WHERE ID=" so many times and that the trace databases is big (around 200 MB) this problem is occuring? But I've actually indexed ID and ip fields...
I want to design a database, using mysql as a backend, and PHP as the frontend, I wanna be able to easily build forms in PHP to communicate with MySQL, is there any programs that will allow this, I really dont want to program all the forms by hand..
thankyou (2 Replies)
Okay, I'm new to this PHP and MySQL stuff, so help would be VERY much appreciated. :)
On my iMac runnning Panther, it has MySQL and PHP installed.
Yet when I view a PHP file from the iMac or another computer at my house, I get the source code.
What's wrong? (11 Replies)
Hi All,
I have a problem with my database having lots of 'stale' slow_queries. I think the problem may be because of the following code:
$numresults=mysql_query("select * from links where catagory=".$catagory." order by linknum");
$numrows=mysql_num_rows($numresults);
I believe this... (4 Replies)
Hello every one
i have question i want to build DATAbase using PHP as interface
i use shell to access to linux . i have in linux psql and SQLplus
i'll call all html files that has db tabels from shell directory.
what should to do before design php pages. can build the database sql design... (3 Replies)
Hi,
The php is not able to connect into my mysql database. But i can able to connect by manually.
I think that I have missed some points.
Please guild for the same.
Thanks,
Mani (1 Reply)
Hi,
I have two websites:
website1.com and website2.com
I didn't write either but have successfully moved all the files from website1.com to website2.com
I (thought) I installed all the correct php modules and website2 is mostly up and running. However, my boss found that when we go to a... (15 Replies)
Hello,
While I was interpretation the PHP manual on database security the recent past, it said that you should by no means connect to the database as the super user but rather as one more user with more limited options.
My question is:
How do you generate new users and set access... (2 Replies)
Hi,
I'm on a Raspberry Pi with Raspbian Wheezy.
I urgently need to get MySQL running with PHP, but I get an error.
For example:
$con=mysql_connect("127.0.0.1","root","******","ids");
gives
PHP Fatal error: Call to undefined function mysql_connect()
So, I found I needed to install some... (2 Replies)
Discussion started by: FreddoT
2 Replies
LEARN ABOUT DEBIAN
catalyst::manual::deployment::fastcgi
Catalyst::Manual::Deployment::FastCGI(3pm) User Contributed Perl Documentation Catalyst::Manual::Deployment::FastCGI(3pm)NAME
Catalyst::Manual::Deployment::FastCGI - Deploying Catalyst with FastCGI
FastCGI Deployment
FastCGI is a high-performance extension to CGI. It is suitable for production environments, and is the standard method for deploying
Catalyst in shared hosting environments.
Pros
Speed
FastCGI performs equally as well as mod_perl. Don't let the 'CGI' fool you; your app runs as multiple persistent processes ready to
receive connections from the web server.
App Server
When using external FastCGI servers, your application runs as a standalone application server. It may be restarted independently from the
web server. This allows for a more robust environment and faster reload times when pushing new app changes. The frontend server can even
be configured to display a friendly "down for maintenance" page while the application is restarting.
Load-balancing
You can launch your application on multiple backend servers and allow the frontend web server to perform load-balancing among all of them.
And of course, if one goes down, your app continues to run.
Multiple versions of the same app
Each FastCGI application is a separate process, so you can run different versions of the same app on a single server.
Can run with threaded Apache
Since your app is not running inside of Apache, the faster mpm_worker module can be used without worrying about the thread safety of your
application.
Widely supported.
FastCGI is compatible with many server implementations, not just Apache.
Cons
You may have to disable mod_deflate. If you experience page hangs with mod_fastcgi then remove deflate.load and deflate.conf from
mods-enabled/
More complex environment
With FastCGI, there are more things to monitor and more processes running than when using mod_perl.
Standalone FastCGI Server
In server mode the application runs as a standalone server and accepts connections from a web server. The application can be on the same
machine as the web server, on a remote machine, or even on multiple remote machines. Advantages of this method include running the
Catalyst application as a different user than the web server, and the ability to set up a scalable server farm.
To start your application in server mode, install the FCGI::ProcManager module and then use the included fastcgi.pl script.
$ script/myapp_fastcgi.pl -l /tmp/myapp.socket -n 5
Command line options for fastcgi.pl include:
-d -daemon Daemonize the server.
-p -pidfile Write a pidfile with the pid of the process manager.
-l -listen Listen on a socket path, hostname:port, or :port.
-n -nproc The number of processes started to handle requests.
See below for the specific web server configurations for using the external server.
WEB SERVERS
Any web server which supports FastCGI should work with Catalyst. Configuration recipies for well-known web servers are linked below, and we
would welcome contributions from people deploying Catalyst on other web servers.
Apache
Catalyst::Manual::Deployment::Apache::FastCGI
nginx
Catalyst::Manual::Deployment::nginx::FastCGI
lighttpd
Catalyst::Manual::Deployment::lighttpd::FastCGI
Microsoft IIS
Catalyst::Manual::Deployment::IIS::FastCGI
AUTHORS
Catalyst Contributors, see Catalyst.pm
COPYRIGHT
This library is free software. You can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2012-01-20 Catalyst::Manual::Deployment::FastCGI(3pm)