Re: Need advice searching large list of objects

[Juan Hernandez Gomez]

Hi, you could create an SQLite table with the properties you want to filter as columns and an extra column with the index of the object in your large list (if not the full object). Then you have the full power of SQL and you can create indexes as needed. Is quite flexible. You haven't said if the list of objects can be updated or is just readonly. Juan Daniel Kersten wrote: Hi all, I have a large list of objects which I'd like to filter on various criteria. For example, I'd like to do something like: give me all objects o where o.a == "A" and o.b == "B" and o.c in [...] I thought of storing references to these objects in dictionaries, so that I can look them up by their values (eg dict_of_a would contain all objects where its value is the object and the key is that objects value of 'a', this way if I do dict_of_a[o.a] I get back [o] (or more elements, if other objects have the same value)) and then look up each field and then perform a set union to get all objects which match the desired criteria (though this doesn't work for the `in` operator). I hope that made sense. The problem is that I have a large list of these objects (well over 100k) and I was wondering if there was a better way of doing this? Perhaps a super-efficient built in query object?? anything? I'm probably doing it wrong anyway, so any tips or ideas to push me towards a proper solution would be greatly appreciated. Thanks, Dan. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Python Ireland" group. To post to this group, send email to pythonireland@googlegroups.com To unsubscribe from this group, send email to pythonireland+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.ie/group/pythonireland?hl=en -~----------~----~----~----~------~----~------~--~---