Martijn Tonies wrote:
LOL - an entertaining read!
Entertaining? I feel to see the humor in his post.
I thought it was concise and well written, with an undertone of I know
I'm swearing in church but So yes, I found it entertaining (I agree
that it was not necessarily humorous
Grant Allen wrote:
Storage engines are unique to MySQL? yes. Is that good? YMMV. Most
of the purported benefits can be achieved with Oracle's features
without the compromises of balkanised storage engines. You're right,
they're not offered by Oracle, or anyone else ... there's a reason
Thanks to everyone who replied - much appreciated.
Ok here is how it went :
1 Creating index first and loading table :saved 1 minute overall
2 Increasing key_buffer - 100M :no difference
3 increasing myisam_max_sort_file_size- 1000M and
myisam_sort_buffer_size-100M
Dear List,
I have a (standard table handler ) table defined as follows :
CREATE TABLE fact0 ( d0keyINTEGER,
d1keyINTEGER,
d2keyINTEGER,
val INTEGER,
filler
Dear List,
I did a data warehouse comparison of a number of databases a while back - for
full details of data structures and queries see :
http://homepages.slingshot.co.nz/~markir
Altho I spent more time on Mysql than any of the others, I was not able to
optimize some aspects as much as I