RE: ignorance? database lookup times

I would expect an increase in performance with the Sun purely based upon the extra horsepower and more memory that you will allocate to Informix buffers. You will gain a little more by making this table memory resident. The sql you run (MATCHES '*something*') forces a sequential scan of the whole table and is bad news for any database. If you (or your users) could eliminate the first *, it would probably return instantly. Murray Wood -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of biggiealec@my-deja.com Sent: Thursday, January 06, 2000 11:10 AM To: informix-list@iiug.org Subject: ignorance? database lookup times I've got a table, with only 500,000 rows, and I'm searching a char(60) field using select url from demourl where url MATCHES '*deja*' This query is taking almost 20 seconds to complete, to me this seems to be taking too long, is there anything I can do to speed this up? This is only an AMD K6-2 300MHz with 256mb ram and a 7200rpm drive. This will be moving to a Sun Enterprise 250 dual 300MHz Ultrasparc-IIi with 512mb ram for production usage, will I notice a large speed increase with that transition? Any help or suggestions would be appriciated. Thanks, -Alec Sent via Deja.com http://www.deja.com/ Before you buy.