On 11/28/06, P Kishor <[EMAIL PROTECTED]> wrote:
On 11/28/06, Craig Morrison <[EMAIL PROTECTED]> wrote:
> Just a bit of warning, as it has bitten a few in the bum, about >3 > character extensions under the NT+ variants.. They can and will bite > you, for instance: > > dir *.sql > > Will list not only *.sql files, but *.sqlite too. > > Imagine: > > del *.sql
fair warning, but totally pointless -- 'del *.s*' will delete all your sql files as well, and so will 'del *.??l*' and and host of other variations. There are many ways of harming oneself, but picking on arbitrarily long extensions as a particularly dangerous one is baseless, afaik.
Note the lack of a trailing wildcard in his example. That was not a typo. The issue there is due to short filenames being matched; the related configuration setting is documented here: http://support.microsoft.com/kb/164351
Recently, I read somewhere (forget the link... should be easy to search for) -- apparently some file extensions are registered within Windows as special files that need to be indexed on every change. One of those extensions is '.dbd' (I could be wrong about the particular extension... but, for the sake of argument, let's just assume it is '.dbd'). So, every time your database changes even a little bit, the OS wants to index it... this person who discovered this phenomenon, claimed it was causing a performance bottleneck.
Windows XP's System Restore tracks and journals the contents of certain filetypes in realtime. I don't have a link for the filetypes handy though. There's a similar issue with some of the desktop search applications trying to index file contents.
Whether or not this is true, the fact is, in Windows (and even in Mac OS X, while using the Finder), three letter extensions mean something special. By making it '.sqlite' (or '.bobbitybob', for that matter), I hope to make my db immune from all this. Actually, even better might be not having any extension at all.
It's not that 3 letter extensions in the abstract are special (both OSes can handle extensions of any length), it's just that most of the logical 1-3 letter extensions have already been used by someone else. I tend to choose long extensions for the same reason. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------