[GENERAL] The database is very slow !

problem of speed directly with the database, because I think that is not normal to need 12 sec to run a query on a table with only 4000 records ... Has anybody an idea ? Thanks Krysto ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] optimisation of a code

q_members .= " AND $id NOT IN (select lead_id from purchase where member_id IN (select member_id_to_exclude from member_exclusion where member_id=member.id))"; $q_members .= " ORDER BY balance_in_points DESC"; $r_members = mysql_query($q_members); $nbdispo = $NBPERSONS_SH

[GENERAL] How to get the total number of rows with a query "limit" ?

could I do else ? Has anybody an idea ? Thanks for the help Krysto ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])