> > (Plus, in memory table would still needs to be populated)
> >
>
> True, but one would suppose that it would have to be faster to populate
> a memory table than one that must be written to disc.

Obviously depends on the available memory and what the server does
with it :-)

Meaning: the server could decide to write it to some sort of temp file.


Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com