We've released a patch for a potential security issue found in the 2.60 release.  If you're running 2.60 please follow the instructions here to upgrade to 2.61:
http://www.interactivetools.com/forum/forum-posts.php?postNum=2233257#post2233257

Please email me at dave@interactivetools.com if you have any questions or need any assistance (we're always happy to help).

Thanks!

Thanks for your feedback.  I've released v2.60 final.  Here's the updated changelog items since the last beta.  

- Admin Backup: These log tables are now skipped during backup: _outgoing_mail, _cron_log (can be overridden with plugin filter backupDatabase_skippedTables)
- CMS Menus: Image preview thumbnails are now limited in height so extremely tall images don't make page too long
- CMS Menus: Dates on list pages now display in whatever format is specified under: Admin > General > Regional Settings
- Compatibility: Fixed PHP 5.5 warning: Deprecated: preg_replace(): The /e modifier is deprecated
- Images: Using new faster image resizing code by default
- Security: Disabled autocomplete on login username and password fields so sensitive data won't be remembered in browser
- Viewers: whereRecordNumberInUrl() now ignores Google AdWords auto-tagging values (gclid) when determining record numbers

You can download the latest version here: https://www.interactivetools.com/order/upgrade.php

Feel free to post any questions on a new thread, thanks!

here is a speed test run from our server using v2.60

I much appreciate your provided examples and explanations.There's a couple of website applications I have in mind that I could use this with and can't wait to test it out on my own.

~ Deborah

Here's some examples of those:

<form action="?" method="get">
  Show records from division(s):<br/>
  A <input type="checkbox" name="division_match[]" value="A">
  B <input type="checkbox" name="division_match[]" value="B">
  C <input type="checkbox" name="division_match[]" value="C">
  D <input type="checkbox" name="division_match[]" value="D">
  E <input type="checkbox" name="division_match[]" value="E"><br/><br/>
  
  Show members from countries (hold ctrl to select multiple):<br/>
  <select name="country_match[]" multiple="multiple" size="5">
  <option>Canada</option>
  <option>USA</option>
  <option>UK</option>
  </select><br/><br/>
  
  <input type="submit" />
</form>

Sure, see our addons page here: http://www.interactivetools.com/add-ons/

I can show all the addons with the keyword "builder" like this: 
http://www.interactivetools.com/add-ons/?name_keyword=builder

And all the addons with the keyword "login' like this:
http://www.interactivetools.com/add-ons/?name_keyword=login

But if you wanted to show addons that contain "builder" or "login" this doesn't work: 
http://www.interactivetools.com/add-ons/?name_keyword=builder&name_keyword=login

Because PHP overwrites the first value with the second (it just shows plugins with "login" in the name).  To get around this you can put [] before the = and it tells PHP to store those values as a list (or array).  And we've added some code to detect that and turn it into an or search.

So now this works (you just need to add [] before the =

http://www.interactivetools.com/add-ons/?name_keyword[]=builder&name_keyword[]=login

You can safely add [] after any fieldname, even if you're just searching for one value.  Here it is in a search form: 

Keyword 1: <input type="text" name="name_keyword[]" value="" /><br/>
Keyword 2: <input type="text" name="name_keyword[]" value="" /><br/>

And you can also do multi-value <select>'s as well.

So anytime you submit a search form or URL with two fields of the same name, so long as there is [] after the fieldname it will do an OR search for all the submitted values.

Hope that makes sense.  Let me know any questions.

I learn best by a code example, if that can be provided.

Thanks in advance.
~ Deborah

The test results I posted are from an installation using two Linux VPSs. One VPS has a solid-state drive and hosts the databases, while a second VPS hosts the websites. I've been very pleased with database responsiveness with this setup as compared to shared hosting.

Thanks for continuing to improve CMSB!

~ Deborah

Actually I'd say those numbers are great.  Even a 100% increase in speed (which would be 2x) is a huge improvement.  I actually get lower numbers on my workstation than on our live website, and it's likely to do with the MySQL configuration, memory & cpu limits, etc.   So the performance is going vary from server to server, and when needed we can research further, but as far as having a checkbox option that can increase the speed of a query, without having to do anything else, I'm still really happy with those numbers.

Out of curiosity, though, do you know the details on your hosting?  For example is shared, virtual private server, dedicated server, internal, or cloud hosting?  And are you on Windows or Linux?

Thanks for posting your results!

~ Deborah

@Equinox - A lot of things could be happening.  The simplest and easiest place to look first is the hosting.  Is she sharing a hosting with all your other clients?  And what kind of hosting plan is it?  It might be worth asking the host to see if they can tell which sites are using all the resources at those busy times.  If another site is using all the server resources it won't matter how efficient we make her site, the server just won't have the resources to server it up quickly.  If the server move is happening soon I'd wait until after that's been done and see if there's still issues, then we could look for the cause at that point.  Let me know if that works.

Thanks!

I'm not completely understanding the indexing issue with the new MySQL but what I gather is that it's a faster way to retrieve specific records or types of records in which specific columns of data are tagged or annotated...is that correct?  If I'm close then I have a client this might work really well for but I'd have to hire you guys to do the modification. Let me give you the scenario and if it's a good fit I can ask Ross for a bid today and pay for the work to get on the pile right away.  My client has about 2-300 customers that she maintains extensive data on. She teaches them and puts each lesson under their membership account, complete with photos, embedded video links, homework and drills.  So, each lesson gets text data entered, anywhere from 1-30  high res photos (but I've shown her reducing the final output size to be more reasonable is helpful and she's complied), video embeds (I talked her out of loading up video directly to her site because it eats up bandwidth and storage and she can have a youtube or vimeo channel for free), and the lesson will pull in drills and points to remember from other sections of the database (ie: "drills" section, "remember" section, maybe "gallery" section).  Each day when she's putting in new lessons for her customers, or modifying some of the previous lessons, she states categorically it's easier and faster for her if she can have the backend database listings page display 1000 records at a time.  While the server is fairly responsive, and CMSB runs very fast, it is still a shared server and so it does bog down at specific times daily.  I've shown her that reducing the listing size to 50, 100 (even 200) and using the search form is exponentially faster during those hard periods but she's adamant to doing it the way she wants (and the customer is always right).  I've witnessed, at this condition, the lessons section take anywhere from 14 seconds to 3 minutes to have the listings page display; whereas the other sections take a fraction of a minute between .14 and .43 seconds.  She also is adamant that up until 3 mos. ago it wasn't bogging down so much.  I take her word at that so if something changed it's most likely a change/challenge on the hosting company's end...either the shared server has simply gone past it's peak and is bogging down, or maybe something happened to it's processes and it's bogging down.  I've shown her specifically how much faster reducing the number of records loading up on the listings screen will keep it running fast...but she won't do it.  So I'm grateful for the timing of the hosting company to move our hosted sites to a brand new set of equipment and update to more recent, and faster versions, of MySQL and pHp (and they give the client the choice of versions so if, for example, she wanted/needed to use M 5.2 with Zend optimizing, that's no problem.  So, in your opinion would setting up the user accounts/lessons sections, or columns, in the database take advantage of this powerful indexing feature?

Thank you kindly!

@Dave - Do you think that CMSB can manage a index on multiple columns?
It is right for curiosity. It is not an immediate need.

Thanks!

Djulia

Do you recommend a particular type for the multi value list fields (VARCHAR, MEDIUM...) ?

You could experiment, but I don't think multi-value list fields are going to see much of a performance boost, so I'd just leave them as auto - or if you know the max length of all the values will be under 255 then varchar(255).  

Multi-value list fields (not single value list fields) are something I'd like to revisit in a future release actually, and store them differently.  Perhaps in a separate table, because while the current method "works", it does let us do as many things as we'd like to through direct MySQL queries.

I've updated the ZIP file with a bugfix for the problem that Djulia discovered, so if you downloaded it previous to this message, please download it again! The only file changed is cmsAdmin/lib/admin_functions.js

Thanks for your excellent detective work, Djulia!

EDIT: I've also attached the file here so it's easier to update.

Do you recommend a particular type for the multi value list fields (VARCHAR, MEDIUM...) ?

Thanks again!

Djulia

It seems that it is the Override jquery.ajax function (in admin_functions.js) which causes this conflict.

I temporarily removed the function and all functioned correctly.

An idea?

Thanks!

Djulia

I've heard of MariaDB, and it's suppose to be compatible with MySQL even having the original MySQL developer(s).  But we don't technically support it since it isn't MySQL.  That said, if it does what it says there shouldn't be any issues.  Good luck with it!  

More info: http://en.wikipedia.org/wiki/MariaDB

Did you try the speed test plugin Tim? Curious what everyone's results were (and MySQL versions which might make a difference).

Can you try reloading the page and clearing your cache? 

1. When I go to the dashboard page in Chrome: cmsAdmin/admin.php?menu=home
2. Then right click > Inspect Element > Click on "Console" tab
3. Then when I run these commands it shows they are defined: 

> $

function (a,b){return new n.fn.init(a,b)} jquery-1.11.0.min.js:2

>jQuery

function (a,b){return new n.fn.init(a,b)}jquery-1.11.0.min.js:2

>$.ajax

(shows code of function)

Is there any errors in the console that show the library isn't loading?  And/or what browser are you using?  Also does your code (or simple jquery code) work on a separate page when loading the jquery with this code block?

<script src="//code.jquery.com/jquery-1.11.0.min.js"></script>
<script>window.jQuery || document.write('<script src="3rdParty/jquery-1.11.0.min.js"><\/script>')</script>

<script src="//code.jquery.com/jquery-migrate-1.2.1.min.js">
</script><script>jQuery.migrateWarnings || document.write('<script src="3rdParty/jquery-migrate-1.2.1.min.js"><\/script>')</script>

<script src="//code.jquery.com/ui/1.10.4/jquery-ui.js"></script>
<script>window.jQuery.ui || document.write('<script src="3rdParty/jquery-ui-1.10.4.min.js"><\/script>')</script>

Let me know what you find out.  Thanks!

var $j = jQuery.noConflict();
$j(document).ready(function(){
    $j('#myid').load('myfile.html');
});

That gives
--
TypeError: $ is not a function
$('form').attr('autocomplete','off');
--

A suggestion?

Thanks again!

Djulia