Yes.
[EMAIL PROTECTED] wrote:
I am assuming that the Memo field is a text datatype and you were
encountering the duplicate key bug.
Original Message <<<<<<<<<<<<<<<<<<
On 2/25/04, 3:28:58 PM, James Lamanna <[EMAIL PROTECTED]> wrot
I am assuming that the Memo field is a text datatype and you were
encountering the duplicate key bug.
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 2/25/04, 3:28:58 PM, Jam
<<<<<<<<<<<<<<<<<<
On 2/25/04, 12:02:43 PM, James Lamanna <[EMAIL PROTECTED]> wrote
regarding Problem with indexes:
So I'm having issues with indexes in mysql 4.0
I issue the following:
Create Index Index1 on Table1 (ParentID,ClassID,Amount,Mem
Can you do a show create table Table1 and see how the index is defined?
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 2/25/04, 12:02:43 PM, James Lamanna <[EMAIL PROTE
So I'm having issues with indexes in mysql 4.0
I issue the following:
Create Index Index1 on Table1 (ParentID,ClassID,Amount,Memo(20));
That works fine. However I'm running into problems when I'm trying to
insert into this table using INSERT I'm receiving errors about duplicate
keys against this
Greetings!
We're having a [reproducible] problem where a query suddenly gets very
slow. The table has a primary key and another key. Any operation that
affects the index, such as insert or update, slows down subsequent queries
that use the index.
Any of the following "fixes" the problem and mak
