ports/116030: pkgdb is terribly slow when managing >1000+ packages

[Georgi Georgiev]

>Number:         116030
>Category:       ports
>Synopsis:       pkgdb is terribly slow when managing >1000+ packages
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Sun Sep 02 22:10:01 GMT 2007
>Closed-Date:
>Last-Modified:
>Originator:     Georgi Georgiev
>Release:        6.2-RELEASE
>Organization:
None
>Environment:
FreeBSD jericho.pcfreak 6.2-RELEASE-p7 FreeBSD 6.2-RELEASE-p7 #4: Thu Aug 30 16:44:23 EEST 2007     root at jericho.pcfreak:/usr/obj/usr/src/sys/JERICHO  i386

>Description:
pkgdb's very slow when there are more than 1000 packages. For example on my desktop machine I have 1290 packages. And because of the slowness of pkg_create and pkgdb when installing a package I have to wait very long. For example pkgdb took more than 8 hours executing and after 8 hours running it was still executing. I consider this a serious bug since the number of packages used by users increase tremendously day by day.
>How-To-Repeat:
Install 1300 freebsd packages (It's better if 20 30 % of the packages to be a large ones with a lot of files in it), then try to upgrade something from ports using portupgrade. Get to bed :|
>Fix:
None

>Release-Note:
>Audit-Trail:
>Unformatted: