PHP & MySql questions - your experience is monetize

• Estado: Closed
• Premio: $10
• Propuestas recibidas: 6
• Ganador: GrumpyDutch

Winner

Resumen del concurso

I have the fallowing questions regarding php & mysql.
Just questions, no codding needed.

- if i run a search on a table of 1mil rows, dose it matter if my value is 3 characters long, or 10 characters long, regarding performance?
- dose it help if i index the table on the column i'm doing the search?

- if i open a connection to my database, and a run a function, that on success runs another function, when should i close the connection. Example:

declare function A(){
open connection
...
function B();

// should i close here?
}

declare function B(){
...
// should i close here?
}


- dose it matter if i do 2 searches in a table, or 1 in a table and other in 1 another table? performance wise

Habilidades recomendadas

• HTML
• JavaScript
• MySQL
• PHP
• Arquitectura de software