Large database - performance issues

Submitted by Jon on 2010/06/03 12:18
I am not sure that this is the proper forum for this, but here goes. I know that Pierre has been steadily improving performance, but for me large databases just seem very sluggish. This has nothing to do with filters, conditional formatting, or auto-assign features. For example, one of my DBs has a grid with a lot of entries (>5000) and exceeds 9 levels deep. Scrolling is a nuisance and refreshing takes forever. I have repaired and compacted the database with little discernable improvement. Do others see this too?
 
Jon
 
P.S. I may be overloading IQ through my own misuse. If so, tell me, but I thought IQ was built for this sort of flexibility. In its early iterations, Ultra Recall was (for me) very slow, but its performance has improved remarkably.

21. Work todo / issues with the online manual

Submitted by KeithB on 2010/06/03 11:03
[Edit] I modified -- link to nonexistent node ID 1693 -- to have child pages for each issue. I believe it will be much easier to manipulate and update.
Also it could be more easily colloborative--submit ideas on each page, contribute what you know, etc
 
I made a this page for the "to-do's" in the online manual. Feel free ta add or revise anything.
This can be our "Mantis" type of system to keep track of things to do.

What can we do to thank Jibz???

Submitted by KeithB on 2010/06/02 20:43
 Apparently Jibz has some awesome technical abilities, and his chm work was incredible.  Any ideas how we can keep him around, and happy?    
I for one, plan to go back and re-read his posts...
 
(edit)  I found a Mouser quote about Jibz, on donationcoder: "Everyone who knows jibz seems to regard him with a kind of reverance.  He's one of the most soft spoken, professional people you'll meet, with an endearing perfectionist streak. He's also one of the most generous programmer's I know, and his help in getting DonationCoder.com off the ground has been invaluable.."
 

Popup for invalid conditional formatting criteria : appears even when valid (but... Read on...)

Submitted by Armando on 2010/06/02 19:20
As I said, this popup appears quite often in my DB, even when the conditional criteria seems to be valid.
 
 
But I think I know why : sometimes , a field appears in a grid, but the condition isn't there in the grid (remember : this is a limitation/feature of the conditional formatting : the field-condition needs to be present as a column  in the grid for the  conditional format to work)
 
So, taking the example in the screenshot : the Followup field will be formatted only if the zzSQLNRequest columns/field is present in the grid.

What would be the ideal UI for item/grid filtering in IQ ?

Submitted by Armando on 2010/06/02 18:21
 
What would be the ideal UI (user interface) for item (displayed in grids) filtering in IQ ?

When IQ is performing an Auto-Backup : "Performing Auto-Backup" popup/dialog could inform user

Submitted by Armando on 2010/06/02 13:56
When DB is big, it takes several seconds to perform an auto-backup. While this happens, IQ freezes. If IQ is going to freeze, a popup should inform the user a a backup is being performed.
 
(I'm also wondering if that backup could be less intrusive ? If yes, maybe the popup would be unecessary)

When copyying/pasting items between 2 DB a confirmation/waiting message should be displayed.

Submitted by Armando on 2010/06/02 00:21
"Nothing happens", in terms of feedback, when items are copied from one DB to another.
I think that users should probably be shown a dialog or a message telling the user that "items are being copied" or something like that.
 
(Note that I noticed that more and more messages like that have been included to the UI in the last 6 months, and I like it a lot -- much more user friendly)
 
Opinions ?

if "negative condition" is used in the filter text box (e.g. WikiTag not like ",,," ) "null" occurences are omitted in results.

Submitted by Armando on 2010/06/01 23:49
 
(This is an oldie, from late 2008 -- still "spring cleaning" my list  :) )
 
Hard to summarize the problem in the title.
 
Steps:
 
1- filter : category not like "*tgsPtral tgsPsupe*"
2- Grid won't show items which have nothing in the category field.
 
Not a bug per se but a bit disconcerting. No ?
Opinions ?
 
I know that the filters UI might evolve, but mentioning it just in case.
 
 
(This is similar to another issue Tom noted with Boolean fields and filtering -- not sure if it was ever put in Mantis)
 

HTML export : MHT content is only exported /visible in browser (if "Copy to clipboard" and pasted in Word : no MHT content)

Submitted by Armando on 2010/06/01 23:12
Time for my weekly bug reports ;).
 
I thought this one was already in Mantis, but no. Steps to reproduce :
 
1- Select a bunch of items with MHT content (not embedded content)
2- ctrl-p --> export to HTML --> Copy to clipboard.
3- Open Word processor (MS Word)
4- paste : Only the item and other fields content will be pasted. No HTML pane content.
 
Note that if you save the export as an HTML file and try to open it in Word, the same problem arises. The MHT content is only visible in a browser -- I guess it's ok if you don't intend to make any edition (or if you plan to use an HTML editor) but ...
 
Waiting for confirmation. Thanks