Closed (fixed)
Project:
Google Maps Tools
Version:
6.x-2.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Reporter:
Created:
15 Sep 2009 at 15:48 UTC
Updated:
17 Jan 2010 at 16:40 UTC
I've briefly looked at the new dev release and there are some changes in gmaps_content_address table schema and table indexes but there's no update function from previous dev release (August 20).
I know this is still a development version but some of us are already using this marvelous and very promising module in production.
Maybe you can provide SQL update queries here if you don't want to touch the release queue.
Anyway thanks for these great modules and keep up the good work.
Comments
Comment #1
xmarket commentedChange is very simple:
- add address part columns from adminarea to thorougfare once again to the table prefixed by 'u_' (stand for 'upper'),
- set the fields like 'u_adminarea = UPPER(adminarea)', alter the indexes as gmaps_content_schema() defines them in gmaps_content.install,
- flush all caches (or at least schema cache).
This is just a performace boost change, which makes possible to eliminate the usage of the SQL level UPPER() function in queries.
Comment #2
xmarket commentedFeel free to reopen, if you have any question.