| From: | brew(at)theMode(dot)com |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: SELECT speed with LIKE |
| Date: | 2000-04-02 21:23:46 |
| Message-ID: | Pine.SOL.4.04.10004021716130.14617-100000@unix01 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> I've got a real problem with the speed of a select. Some folk might
> "SELECT * FROM data WHERE stname LIKE 'MAIN%'"
I once had a speed problem on mSQL and found if I only selected the
columns I needed, rather than use a wildcard to get them all, it ran much
faster. Of course, this is a different database program and maybe you
need the data from every column in your application, but it's something to
try.....
brew
==========================================================================
Strange Brew (brew(at)theMode(dot)com)
Check out my Musician's Online Database Exchange (The MODE Pages)
http://www.TheMode.com
==========================================================================
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Frank Bax | 2000-04-02 23:24:03 | Re: SELECT speed with LIKE |
| Previous Message | Dave | 2000-04-02 20:30:37 | Re: [PHP3] Job openings (FreeBSD/C/php/postgresql) |