DRI is organizing an open SugarCRM event again. The event takes place in Lisbon, 19th of May.
I had the honor to take part in the project GalpShare, which will be featured as one of the case studies. If you are in or around Lisbon, don’t miss it!:)
This is an archive post. It represents a point of view in the past. Facts might have changed, events might be interpreted differently as of today. Links might be broken.
If you like Ext JS, the new 2.2 version brings out some nice features for you. No question Ext is a great library and worth to play with, despite the recent disputes around the license change from LGPL to GPL.
My only frustration with Ext was only a few days ago, when i was about to make modifications in an open source project that had an earlier Ext 2.0 bundled, but not fully! So where can i get the full Ext 2.0 package to add some adapter files that were missing?
…ok, so i was doing some database tuning recently to speed up one of our deployed instance of SugarCRM, when i became alert of an interesting phenomenon.
The table accounts not only had a primary key(id), which is normal, but also had a composite key(id, deleted) named idx_accnt_id_del. Now wait a minute! Even if you perform a query with id AND deleted criteria, id already points to a single record in the table, since it is a unique primary key. Thus the composite key makes absolutely no sense!
Mysqlperformanceblog, which i have read a lot lately, confirms my findings.
I didn’t try any of the tools they mention in the comments section, but by quickly searching for “id_del” in Sugar vardef files reveals that the following tables have the same problem:
- roles
- acl_actions
- acl_roles
- fields_meta_data
Just one week from now we will have a big SugarCRM event in Portugal. It is organized by DRI, amongst the speakers we will have Clint Oram, vice-president and co-founder of SugarCRM. I am really looking forward to be there, and i am also proud that i took big part in two of the projects that will be presented as case studies.
Website of the event (portuguese only): www.eventocrm.com
This is an archive post. It represents a point of view in the past. Facts might have changed, events might be interpreted differently as of today. Links might be broken.
At dri, we recently published our first SugarCRM project called Sugar Bookmarks. Download count at 27 at the moment:)
This is an archive post. It represents a point of view in the past. Facts might have changed, events might be interpreted differently as of today. Links might be broken.