Re^5: How to improve MYSQL search performance of perl?

The "Internal Server 500"-error is probably due to the fact that your script generates an error and terminates, thus bringing down that part of your Apache server with it. What do you find in the error-log of Apache?

Do you check all your DBI-methods for errors? Use CGI::Carp so you are sure all your errors are logged to the error-log and can be checked later.

Can you run your script outside of the Apache-server and if so what is the result?

CountZero

"If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law

Comment on Re^5: How to improve MYSQL search performance of perl? Download Code

Replies are listed 'Best First'.
Re^6: How to improve MYSQL search performance of perl? by nan (Novice) on Aug 25, 2005 at 15:56 UTC
Hi, If I run the script outside of the Apache-server, it's ok but just very slow. The error log says "Unrecognized escape \\h passed through at F:/httpserv/Top/cgi-bin/search.pl line 18" but line 18 is database connection: my $dbh = DBI->connect('DBI:mysql:diet', $ref) \|\| die "Failed to connect: $DBI::errstr"; thanks again, Nan	[reply]