Re: Optimizing ORDER BY any ideas?

[Marc Van Olmen]

hi Jay,

thanks for your thoughts on this. The query is just a smaller version of bigger query that takes about 3 seconds in the end. I just narrowed the bottleneck down to this query. Sorting takes time I agree... but sorting shouldn't take time at all in my opinion if you could preindex the order....

For example when I do select/sorting on one table the sorting happens in 0.0003 seconds on the same amount of records because it is using the index.

For reporting I need to do like 20 times similar query, so it takes a minute to generate the report... so looking for a way to optimize the query....

just was hoping that with some indexing trick I could optimize a few things...

I have written my own database algorithms for database a few years ago that does some similar things in miliseconds.

Should I think about creating temporary table or a view? I'm using 5.0b12.

For example a few thoughts... I had about it... could I sort in a view or temporary table the T_SALES_ORDER_ITEM first in a temporary table on the field... PRY_EXPORT_CITY from the other table...

just some random thoughts I had, just looking for some more input ideas on this matter.

thx

marc