Re: please help optimize this query

2006-06-01 Thread Joseph Alotta
May 31, 2006 12:25:50 PM CDT To: "Joseph Alotta" <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Subject: Re: please help optimize this query I'd start by looking at your schema.. Quite a lot of use of varchars... I'd suggest using chars (takes more space but processes fas

Re: please help optimize this query

2006-05-31 Thread DreamWerx
I'd start by looking at your schema.. Quite a lot of use of varchars... I'd suggest using chars (takes more space but processes faster).. Or even better, normalize the data so that you have a table for symbols that is linked to this table via an integer based foreign key. Also it seems wierd fo