[Kyle]

Hi,

I've this code and it has 168 rows of data to collect.

"SELECT * FROM userdrugs WHERE Username='%s' LIMIT 0,1"

Here is half of the structure:



It goes upto gram179. For it to select and obtain the data it takes around 5 seconds.

What can I do to optimise and make it faster?

Thanks.