Don't use CONTAINS. You might find it faster to use LIKE
(%+t2.shortcut+%), but I would continue with EQ. CONTAINS to the best of
my knowledge does not use indexes.
Albert
On 11/27/2013 10:41 AM, Michael J. Sinclair wrote:
Hi all,
With Rbase 9.5 32 on Windows XP this command works fine and very fast...
UPDATE scripts1 SET PRINTER = PRINTER FROM scripts t1, +
scripts1 t2 WHERE t1.namedose CONTAINS= t2.shortcut AND t2.patnumbr =
.vpnum AND +
t2.PRINTER IS NULL
With Rbase 9.5 32 on Windows 7, it takes 11 seconds to complete the
same command, despite the faster processor and faster memory. NIC and
Harddrive specs are the same.
If I get rid of CONTAINS and change it to = like this....
UPDATE scripts1 SET PRINTER = PRINTER FROM scripts t1, +
scripts1 t2 WHERE t1.namedose = t2.shortcut AND t2.patnumbr = .vpnum AND +
t2.PRINTER IS NULL
then it works instantly on both Windows XP and Windows 7.
Both tables, scripts1 and scripts have an index on the column called
namedose.
What can I do to make it faster on Windows 7?
Mike
