Hi!
On Mar 05, Klaus Weyhe wrote:
Hello ... Is there anybody out there..,
who can tell me how to create the parameteres for the mi_rkey function in
the myisam library.
I've tried to create the key by concatenating the key segments.
Apparently that dosn't work. I get errcode 120,(Key not found ??).
I'm trying to migrate from INFORMIX c-isam to MySQL.
Besides: Have I understood the manual right, when I asume that descending
key are not allowed(only ascending) ??
Several points -
1. you'd better send this email to [EMAIL PROTECTED],
it was created for questions like this
2. take a look at mi_test?.c examples - there're multi-seg keys there.
3. descending keys are allowed. There's flag HA_REVERSE_SORT
4. To migrate from c-isam there's no need to use MyISAM functions
directly. Take a look at MySQL HANDLER command - it provides direct
access to low-level isam functions, bypassing SQL optimizer.
You'll get client-server architecture, and - most probably -
higher performance with it (due to cache issues).
Btw, this HANDLER comand was created precisely to simplify
c-isam - MySQL migration.
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
___/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php