My non-BW solution would be to setup a cron scheduled process, that creates an index with the info you want. This process could run as often as needed once an hour, twice a day .... and would have little impact on your system.
The process would create a new index each time leaving the existing list alone until it is complete and then switching it out for the new list. Could be done with BW code or as a basic unix script I would imagine. Storing dates is ISO date format makes them easy to be sorted (YYYY-MM-DD HH:MM:SS) or you could chop off anywhere along that date path (if you don't need seconds for example). After you have collected all the data, the data can then be sorted so that it is in chrono order. You could even store info in the index that you want to display without having to actually look at the pages themselves when you use it. This way when you display the list on your page, you have all the info you need in the index itself. It would not have to even look at the pages on the system to display the data then. Like (using my favorite delimiter ::: ) 2009-05-10 22:50:::pagename:::title:::some other data... 2009-05-10 23:05:::pagename:::title:::some other data... 2009-05-11 04:14:::pagename:::title:::some other data... ... This would eliminate the need for a database, would be lightning fast when reading the index and would already have the info in date sorted order. On Thu, Oct 15, 2009 at 2:32 AM, Martin <[email protected]> wrote: > > I know that tracking down the bugs is priority one at the moment, but > I need an advice how to solve a sorting problem. > > The problem: > - hundreds of pages > - should be sorted chronologically on the homepage > - in addition: pages are dated in advance (ignore if page date > > server date) > - cannot use timestamp or date in url (imho the easiest and fastest > solution) > - each page has a timestamp in data field > > I am afraid that double checking all data fields (compare to server > time and sort) when opening the homepage would take too long. > Shall I keep an info list with dates and pagenames? The downside: > Thats another list to keep an eye on. > > Any ideas? > > Greetings, Martin > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "BoltWire" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/boltwire?hl=en -~----------~----~----~----~------~----~------~--~---
