e_2512 — 2010-07-24T11:16:33-04:00 — #1
plz i have question .. is when i write sql command which include more than lef join statement .. is it exhause the server and database engine resources ??
or it's normal ?
r937 — 2010-07-24T13:43:41-04:00 — #2
in general it is better to optimize the execution of a single query
do you have any indexes on your tables?
e_2512 — 2010-07-24T13:17:08-04:00 — #3
thx alot mr r937 .. so i want ask u another question please .. so in your opinion .. in general it's prefere to divid the sql query to many sql quires instead of collect all in one query using left join ? .. is it will not cause any resources exhaust ? Or any slow ?
r937 — 2010-07-24T12:07:07-04:00 — #4
exhaust resources? yes, it's possible, but usually only if you wrote a bad query
since you did not show your tables or your query, that's all i can say
e_2512 — 2010-07-25T06:48:04-04:00 — #5
r937 — 2010-07-24T21:28:22-04:00 — #6
are the indexes optimized for the query that you're running?
e_2512 — 2010-07-24T19:30:35-04:00 — #7
yes mr r937 each table have index .. ?
r937 — 2010-07-25T07:14:01-04:00 — #8
okay, then you should be fine
e_2512 — 2010-07-25T07:28:14-04:00 — #9