Op maandag 21 november 2005 09:21, schreef Adrian Rossouw:
On 21 Nov 2005, at 10:15 AM, Bèr Kessels wrote:
Op maandag 21 november 2005 07:08, schreef Liza Sabater:
the only one that thinks 1 million aliases might be a bit silly to generate automatically?
yes.
No
There will only (really) ever be as many aliases as you have nodes / users.
If you have 1 million nodes/users, you have for more problems than the path_alias table.
The path alias table is really simple, and we improved the performance a ton, so it only loads aliases as needed (instead of caching all of them the whole time)
No, nAliases = nPages = nNodes + (nUsers * 2) + (nTags ^ nTags) + (nByModules) (nByModules, for tagadelic, 2 * (nVocabularies ^ 25), or for image: nImages + nGalleries) so, nAliases can be enourmous, humongous, redicoulous big, if this is to be used, we need to follow Moshes road of 'dynamic' aliases, i.e. aliases made on-the-fly. That is, what I wanted to do for tagadeli. So, not store /tagadelic/chunk/Foo, /tagadelic/chunk/Foo+Bar /tagadelic/chunk/Foo,Bar /tagadelic/chunk/Foo+Faa and so on, but rather just match Foo, Faa, Bar against the db on call of that page. Bèr -- PGP ber@webschuur.com http://www.webschuur.com/sites/webschuur.com/files/ber_webschuur.asc PGP berkessels@gmx.net http://www.webschuur.com/sites/webschuur.com/files/ber_gmx.asc