Hi Vishal,
thank you for your reply. INTERNAL and NONINDEXED work fine. Just MYSQL as indexing scheme does not work at all.
I just did mysql (which has InnoDB and Collation latin1_bin): show index from glinks_Links; which shows the following.
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+--------------+------------+-----------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+
| glinks_Links | 0 | PRIMARY | 1 | ID | A | 83827 | NULL | NULL | | BTREE | |
| glinks_Links | 1 | expiryndx | 1 | ExpiryDate | A | 4 | NULL | NULL | | BTREE | |
| glinks_Links | 1 | expiryndx | 2 | ExpiryNotify | A | 4 | NULL | NULL | | BTREE | |
| glinks_Links | 1 | expcntndx | 1 | ExpiryCounted | A | 4 | NULL | NULL | | BTREE | |
| glinks_Links | 1 | expcntndx | 2 | ExpiryDate | A | 4 | NULL | NULL | | BTREE | |
| glinks_Links | 1 | popndx | 1 | isPopular | A | 2 | NULL | NULL | | BTREE | |
| glinks_Links | 1 | valexpndx | 1 | isValidated | A | 4 | NULL | NULL | | BTREE | |
| glinks_Links | 1 | valexpndx | 2 | ExpiryDate | A | 4 | NULL | NULL | | BTREE | |
| glinks_Links | 1 | stndx | 1 | Status | A | 24 | NULL | NULL | | BTREE | |
| glinks_Links | 1 | newndx | 1 | isNew | A | 2 | NULL | NULL | | BTREE | |
| glinks_Links | 1 | userndx | 1 | LinkOwner | A | 10 | NULL | NULL | | BTREE | |
| glinks_Links | 1 | urlndx | 1 | URL | A | 18 | NULL | NULL | | BTREE | |
+--------------+------------+-----------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+
I would have expected Title, Description etc.
Regards
Niko
thank you for your reply. INTERNAL and NONINDEXED work fine. Just MYSQL as indexing scheme does not work at all.
I just did mysql (which has InnoDB and Collation latin1_bin): show index from glinks_Links; which shows the following.
Code:
+--------------+------------+-----------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+--------------+------------+-----------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+
| glinks_Links | 0 | PRIMARY | 1 | ID | A | 83827 | NULL | NULL | | BTREE | |
| glinks_Links | 1 | expiryndx | 1 | ExpiryDate | A | 4 | NULL | NULL | | BTREE | |
| glinks_Links | 1 | expiryndx | 2 | ExpiryNotify | A | 4 | NULL | NULL | | BTREE | |
| glinks_Links | 1 | expcntndx | 1 | ExpiryCounted | A | 4 | NULL | NULL | | BTREE | |
| glinks_Links | 1 | expcntndx | 2 | ExpiryDate | A | 4 | NULL | NULL | | BTREE | |
| glinks_Links | 1 | popndx | 1 | isPopular | A | 2 | NULL | NULL | | BTREE | |
| glinks_Links | 1 | valexpndx | 1 | isValidated | A | 4 | NULL | NULL | | BTREE | |
| glinks_Links | 1 | valexpndx | 2 | ExpiryDate | A | 4 | NULL | NULL | | BTREE | |
| glinks_Links | 1 | stndx | 1 | Status | A | 24 | NULL | NULL | | BTREE | |
| glinks_Links | 1 | newndx | 1 | isNew | A | 2 | NULL | NULL | | BTREE | |
| glinks_Links | 1 | userndx | 1 | LinkOwner | A | 10 | NULL | NULL | | BTREE | |
| glinks_Links | 1 | urlndx | 1 | URL | A | 18 | NULL | NULL | | BTREE | |
+--------------+------------+-----------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+
I would have expected Title, Description etc.
Regards
Niko
