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

Hi,

After reading through Chapter 10 in MySQL Reference Manual, I'm trying to rebuild the table and index and I'll let you know what happens after that.

Actually, the error log just says "personal.pl: Unrecognized escape \\h passed through at F:/httpserv/Top/cgi-bin/personal.pl line 11., referer: http://localhost/form.html" but the line 18 is about database connection:

my $dbh = DBI->connect('DBI:mysql:diet', $ref) || die "Failed to connect: $DBI::errstr";

And it's weird that the script works fine without using Apache server...

Many thanks,

Nan

  • Comment on Re^6: How to improve MYSQL search performance of perl?

Replies are listed 'Best First'.
Re^7: How to improve MYSQL search performance of perl?
by davidrw (Prior) on Aug 25, 2005 at 17:44 UTC
    error says line 11, you say that line 18 is the DBI connect line... can you provide the whole (or at least top section) of the script? If you search, is there a " \h" anywhere (in a windows-style filename maybe)?