Improvement Data Search

[uyuni]

Hello,

Data Search is great! But of course it is a little slow when you have a lot of tables. It would be great when Data Search is configurable:

– In which tables and fields is the text searched. Normally I always search in the same ~10 fields and I have more than 100 tables in my database. There could be radiobuttons next to the search button “search in defined fields”/”search in all fields”.

– This definition should be separate for numbers and text. A number (ID) should be searched only in defined number-fields.

Also the top/bottom-margin of the result could be a bit smaller. On my notebook with as small screen the margin takes too much space.

[peterlaursen]

We know. And already have http://code.google.c…detail?id=1648. Feel free to add yourself there if you find that it is not fully what you tell here.

Obviously Data Search will fire a lot of simple queries with a WHERE or REGEXP -clause of which many may not be well-optimized (as in lots of cases an index will not be used). As the first step we will add an option to search only specific tables of a database and/or specific columns of a table. One developer has started this today actually.

A few more specific replies:

* As long as we use the LIKE operator with %-wildcards all data are handled as strings. MySQL has no problem with this.

I think personally that searching a subset of tables in a database for isntance should be handed by Object Browser selection of those tables (and not more checkboxes or whatever). But next review meeting in SQLyog team should decide final implementation details.

[Author]

Posts