I'm querying a table of approximately 42 records based on 3 criteria. The results are then displayed in a pop-up window. When the query is executed the first time - the window opens and stalls for about 3 seconds before the results are displayed.
An example query would be : select * from $table_name where email ='$id'"; I'm using the * to retreive about 16 cols of information per row. In this case I have indexed the email column. I'm looking for faster performance. Any help is appreciated. Mark