Shitiz Bansal schrieb: > I need to implement a system which stores Strings(average length 50 chars). > I was wondering what would be the most efficient(timewise) solution for > this riddle.
I'd use pysqlite, a SQL database in a file. > For every input String it would need to tell the user wether that string > already exists in the system. Create the string column as "UNIQUE". > It would also need to add that input > String to the system if it did not exist. Select the string to be inserted, if there is no result, you can insert the new string. > It will also be useful to know > the last accessed datetime value of that string. Just add a column with type TIMESTAMP and update that accordingly. > The number of strings is in millions Should be no problem with SQLite, if the strings are short. Chris _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
