HOW speed up slow script ? (3500 lines/ 130 kb)
| From: | helmut ott | Date: | Mon, 05 Jun 2000 18:54:11 +0000 |
| Subject: | HOW speed up slow script ? (3500 lines/ 130 kb) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-1081@lists.php.net to get a copy of this message | ||
I have a one in all script (php/mysql/unix) for list and detail views and add, edit, delete
functions. alltogether 3500 lines of code / 130 KB. A record has 140 fileds, with right now only 100
records in the database. The query takes about 15 seconds for a "list all records"-query.
And thats pretty slow. But I want to put at least 30000.
WHAT should I do to speed it up (e.g. built indexes, split up script ......) ?
Helmut