> > On a related note, I wanted our phones to display "city, st" for the > > caller-ID name in the event that none was provided. > > Interesting code. What sort of memory does * take up when you load up > all those CLID values? > > Nathan > I am a little late to this thread, but the answer is WAY TO MUCH.
With 150,000 "pattern" match extensions * takes a very long time to reload, during which time calls do not proceed. If you use Realtime MySQL it pulls in ALL patter match extensions in the context on every call (150,000 rows per query). There are two ways to fix this; The one we did, use the application command realtime() to pull the record from a database based on napnxx and then use gotoif to route to the lowest cost provider in that records (realtime must be used on a unique index so ONLY 1 row is retruned). We are testing upgrading this to mysql 5 where a view could be used to eliminate the gotoif. With the gotoif and 2 carriers per npa nxx it is fast. Realtime() can only do simple queries as of right now, so views would be a huge plus. The other option I know others are using is to get the route via an agi script. Bottom line, YOU CAN NOT load all 150,000 NPA/NXX pattern matches in asterisk via text file or realtime and expect acceptable performance, YOU MUST use a database query solution to get only info you need to * BTW - for $5/mo you can have access to a reasonably well maintained complete listing of NPA/NXX/OCN/CLLI/ADDRESS, ETC. https://www.telcodata.us/secure/account/signup (no affiliation) _______________________________________________ --Bandwidth and Colocation sponsored by Easynews.com -- Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users