Query Timeout

[cfultz51]

Is there a way for me to speed up a query? I have a table that is called payment which have about 10k lines. It times out before the query is done. I have used set_time_limit (120) but that takes way to long. Should I make tables for each indivial person, etc? What can I do please?

[NogDog]

Probably most important: make sure you create indexes on any columns which are used in the WHERE clause of your query.

Otherwise, without knowing what DBMS you are using, what sort of query you're trying to do, etc., there's not much else to say.

[bokeh]

My guess is something else is wrong. I just did a test on a table I have with 77,000 lines and it took 240 milliseconds. Are you running this on an Atari.