Re: [SQL] SQL Query Performance tips

2005-01-31 Thread Michael Ossareh
Hi PFC Thanks for this! It has sped up complete - now in fact there is no delay! A few tweaks had to be made to the code ; here it is: select breakdown.alignment, sum(cnt) as num FROM ( (select alignment.name as class, count(1) as cnt from weapons, alignment where weapons

[SQL] SQL Query Performance tips

2005-01-14 Thread Michael Ossareh
nance will quickly become a headache due to the number of purchase routes in the project. Any help is much appreciated. Thanks, ---------- Michael Ossareh (M²) Technical Manager 12snap UK Ltd ---(end of broadcast)--- TIP 6: Have you

[SQL] MO: SQL Query Performance tips

2004-12-06 Thread Michael Ossareh
nance will quickly become a headache due to the number of purchase routes in the project. Any help is much appreciated. Thanks, ---------- Michael Ossareh (M²) Technical Manager 12snap UK Ltd ---(end of broadcast)--- TIP 2: y