On Nov 20, 2014, at 2:53 AM, René J.V. Bertin wrote: > On Thursday November 20 2014 09:24:56 Clemens Lang wrote: > >> The slowness occurs because a database query uses an index to select all >> files >> installed by the port currently being processed and then continues to scan >> over >> this list for a specific entry. >> >> Obviously, for ports that install less than, let's say, a thousand files, >> this >> causes the database software to do a scan across 1000 items 1000 times (once >> for each file we're activating). Of course now with boost, which installs >> some >> 35k files, that's 35k^2. You see where this is going… > > Are you saying that for each file, you first look up the port again and > again, which is probably an operation of a certain cost too? > > What is the point of all those scans, if I may ask?
There is no point; it's just a bug. We were simply not using the most efficient SQLite index possible, and the problem did not manifest until the new version of SQLite in Yosemite appeared. Clemens believes he has fixed the problem in trunk. _______________________________________________ macports-users mailing list [email protected] https://lists.macosforge.org/mailman/listinfo/macports-users
