Am Samstag, 28. Februar 2004 16:41 schrieb Timwi:
I think you are greatly underestimating the powerful
optimisations that
can be done (and are done) in MySQL. Parsing an SQL statement is trivial
Yes parsing ist easy... but transform it to an optimal expression of
relational algebra is not easy... Thus it would be better to use it
directly...
(in terms of required computational power); I
don't know much about
relational algebra, but it seems that you would somehow have to express
and then parse statements in that algebra too. If you don't have an
That depends on how you have to write down the expression... But we both
stated parsing is not the problem.
index, then operations on huge tables are slow no
matter what data
structure you use.
You have to know for what reason you want the index... Most of the special
functions can be switched on, if we just use an index for each of them...