Hi, Marc - I hope you have solved your problems during my absence. We
took the trailer and visited Waterton-Glacier International Peace Park
Thursday through yesterday. From my readings of this list, I get the
impression that there is no indexing possible on VARCHAR columns. Even
so, I suspect that you got a significant speed increase with the two
column compound index.
Albert
MDRD wrote:
Albert
CREATE INDEX SxTC ON `TravCard` ( `Subjx` ASC )
error
this works
CREATE INDEX SxTC ON `TravCard` ( `sympt1` ASC )
Subjx is a Varchar, Is Indexing Varchar is allowed??
This is my first Varchar column.
Marc
--------------------------------------------------
From: "Albert Berry" <[email protected]>
Sent: Wednesday, July 14, 2010 3:19 PM
To: "RBASE-L Mailing List" <[email protected]>
Subject: [RBASE-L] - Re: How to make this Delete command faster
Try the command without the IDQUOTES around the tables and columns.
You never know - stranger things have happened. I should also have
mentioned the column order in descending frequency of nulls - my bad.
Albert
MDRD wrote:
Albert
This is may IDQUOTES, also I tried the same syntax with the ` `
around the Table and Columns.
IDQUOTES `
Thanks
Marc
--------------------------------------------------
From: "Albert Berry" <[email protected]>
Sent: Wednesday, July 14, 2010 1:47 PM
To: "RBASE-L Mailing List" <[email protected]>
Subject: [RBASE-L] - Re: How to make this Delete command faster
Check your IDQUOTES setting.
Albert
MDRD wrote:
Sorry to be so dense today.....
I created the 3 column index on a test DB
Unload the structure of that table
Copy and paste the Index code to run on the live DB
CREATE INDEX SxTC ON `TravCard` +
(`TxDate` ASC , +
`sympt1` ASC , +
`Subjx` ASC )
Syntax error, how is that possible, when I cut and pasted it from
the Unload Structure output?
Marc
--------------------------------------------------
From: "Albert Berry" <[email protected]>
Sent: Wednesday, July 14, 2010 11:05 AM
To: "RBASE-L Mailing List" <[email protected]>
Subject: [RBASE-L] - Re: How to make this Delete command faster
Try putting a compound index on the table.
CREATE INDEX travcarddelete ON travcard (txDate, sympt1, subx)
Albert
MDRD wrote:
Hi
This command takes too long when we run it from a workstation
but I can not think of any way to speed it up.
txdate is Indexed
symptom is Text 150 no Index we will not search on this column
subjx is Varchar no Index and we will not search on this column
either
DELETE ROWS FROM travcard +
WHERE txdate = .#DATE AND sympt1 IS NULL AND subjx IS NULL
any suggestions?
Thanks
Marc
