From: <ben...@ug...> - 2007-01-15 20:59:13
|
Quoting Richard Taylor <rjt...@th...>: > > Filters are another problem area. To be able to filter a table you have to > load in every record and compare it to the filter, this can obviously take a > very long time if you have 100,000+ records. This should not really be the case. If you filter on a .gramps xml text file of 20 Mb with good regex construction, it should not take more than a couple of seconds. I need 3sec to regex a flat text file of 300Mb. It all depends on how you design search and view. Filter now loops over all handles I have the impression, but this can be written for some to loop over indices first, then records. On a database implementation there should be no reason to have a slow application. Let's be honoust, 100.000 records should be peanuts, you never see more than 50 on a single screen. Benny > > Regards > > Richard > > > On Monday 15 January 2007 20:15, Gerald Britton wrote: >> The problem with the standard people view and large databases is the >> tree view. Probably the database could have an additional index or >> two to take care of the problem. On the other hand, providing an >> alternative, flat people view might be handy and not just for >> performance reasons. >> >> With a flat view, it would also be possible to active column sorting >> in the view -- something I know that I would use. >> >> On 1/15/07, Richard Taylor <rjt...@th...> wrote: >> > On Monday 15 January 2007 19:44, Kees Bakker wrote: >> > > Here are some figures about my father's database (on an AMD 3200+ with >> > > 1Gb mem). >> > > >> > > - reading in a 5Mb GEDCOM with 24353 people in 9750 families takes >> > > about 3,5 minutes >> > > - the resulting database is about 100Mb >> > > - opening that 100Mb database takes roughly 30-40 seconds >> > > - in people view the clicking on the little triangles is very >> > > confusing because of the slow feedback (When I showed this to my 84 >> > > year old father he clicked a few times on a triangle and nothing >> > > happened. It took 5 seconds before the list unfolded. That is, a >> > > surname list with a lot of people, which is not unusual if you have a >> > > genealogy for your own family. Now if you click twice it takes 10 >> > > seconds without any visible result.) - scrolling in people view using >> > > PgUp and PgDn will confuse the display of the cursor line (the blue >> > > line with the selected person) >> > > >> > > The last two items make Gramps simply not-usable for my father. >> > >> > Would you say that it is the speed (or lack of) that is the primary >> > problem or the lack of feedback? >> > >> > It may be possible to add some user feedback for operations that are >> > taking a long time. I am not sure that it will ever be possible to make a >> > database with 100,000+ records work very quickly in gramps. The View >> > model will always be slow with that many records. >> > >> > Richard >> > >> > ------------------------------------------------------------------------- >> > Take Surveys. Earn Cash. Influence the Future of IT >> > Join SourceForge.net's Techsay panel and you'll get the chance to share >> > your opinions on IT & business topics through brief surveys - and earn >> > cash >> > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >> > _______________________________________________ >> > Gramps-users mailing list >> > Gra...@li... >> > https://lists.sourceforge.net/lists/listinfo/gramps-users > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Gramps-users mailing list > Gra...@li... > https://lists.sourceforge.net/lists/listinfo/gramps-users > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. |