The following is the table structure that I'm using, only one field, 'codice' is Primary key and not null, all others may have or may not have data inside.
+-------------+----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+----------------------+------+-----+---------+-------+
| codice | smallint(5) | | PRI | 0 | |
| titolo | varchar(100) | YES | | NULL | |
| registac | varchar(15) | YES | | NULL | |
| registan | varchar(15) | YES | | NULL | |
| attore1c | varchar(15) | YES | | NULL | |
| attore1n | varchar(15) | YES | | NULL | |
| attore2c | varchar(15) | YES | | NULL | |
| attore2n | varchar(15) | YES | | NULL | |
| attore3c | varchar(15) | YES | | NULL | |
| attore3n | varchar(15) | YES | | NULL | |
| annofilm | smallint(4) unsigned | YES | | NULL | |
| durata | smallint(3) unsigned | YES | | NULL | |
| genere | varchar(10) | YES | | NULL | |
| descrizione | text | YES | | NULL | |
| dataacq | date | YES | | NULL | |
+-------------+----------------------+------+-----+---------+-------+
15 rows in set (0.00 sec)
searching speed is low, it take about 18 sec before open the "query" page that is <!-- w --><a class="postlink" href="http://www.chivideo.it/cerca.php3">www.chivideo.it/cerca.php3</a><!-- w --> .
There are 4 SELECT queries inside, and all of them are pointing to a defined field name.
They are needed in order to put data inside combo boxes. Table has about 2500 records of text using only smallint, varchar and only one text field type.
What can I do to increase performance ?
thank you for your help!
Fabio
+-------------+----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+----------------------+------+-----+---------+-------+
| codice | smallint(5) | | PRI | 0 | |
| titolo | varchar(100) | YES | | NULL | |
| registac | varchar(15) | YES | | NULL | |
| registan | varchar(15) | YES | | NULL | |
| attore1c | varchar(15) | YES | | NULL | |
| attore1n | varchar(15) | YES | | NULL | |
| attore2c | varchar(15) | YES | | NULL | |
| attore2n | varchar(15) | YES | | NULL | |
| attore3c | varchar(15) | YES | | NULL | |
| attore3n | varchar(15) | YES | | NULL | |
| annofilm | smallint(4) unsigned | YES | | NULL | |
| durata | smallint(3) unsigned | YES | | NULL | |
| genere | varchar(10) | YES | | NULL | |
| descrizione | text | YES | | NULL | |
| dataacq | date | YES | | NULL | |
+-------------+----------------------+------+-----+---------+-------+
15 rows in set (0.00 sec)
searching speed is low, it take about 18 sec before open the "query" page that is <!-- w --><a class="postlink" href="http://www.chivideo.it/cerca.php3">www.chivideo.it/cerca.php3</a><!-- w --> .
There are 4 SELECT queries inside, and all of them are pointing to a defined field name.
They are needed in order to put data inside combo boxes. Table has about 2500 records of text using only smallint, varchar and only one text field type.
What can I do to increase performance ?
thank you for your help!
Fabio