This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Wouldn't the internal html viewer also be less likely to be a malware vector simply because the IE control is a rich target for malware?Yes - in fact in the option they write "not susceptible to Internet Explorer vulnerabilities".
Where many of the entries are variations on the same base, user01 user02 user1979 user1980 etc.. my last suggestion would be only store the "base" of the dictionary entry and generate the variations.And that can be an interesting idea
How would I use/apply this?Just use some DB manager for SQLite, like this SQLite Database Browser, or the command line version or there are many other programs.-bhuiraj (May 02, 2011, 05:33 PM)
I don't see what you suggested that I didn't already in this post:Nothing of new, just a real implementation, because we don't know how fast is a DB with a keyword as a key. And I can say that is very fast and do not need so much ram, but need hard disk space. Maybe enterprise DB (like Oracle/MySQL/etc.) can handle GB of data better than SQLite, but the system is the same.
https://www.donation....msg245865#msg245865-MilesAhead (May 02, 2011, 05:36 PM)
The trouble with using a relational database in this case is the key is the only data. You're not saving anything or creating any efficiency. If I have 3 paragraphs of text with key "ProfIrwinCoreySpeach" then I can use the key to get the data. With the dictionary, there is no other data. There's nothing to optimize.What do you mean?
You could split the files according to first character as you say. But the only good way would be to build as you go along. Having 33 GB of spaghetti data to unravel at the start makes it unwieldy.Of course, once you have the file well organized, the next time you add new keyword you must insert in the correct way. Or, you can have some background process to sort the file for binary search. Or, you can create index file (to make a fast search) to unordered data.