> From: "Vlad Khorsun" <[email protected]>
>>
>> What are you going to do, when databases will overflow this single
>> directory ? Buy new HDD ? Create new
>> directory and teach application to look for databases at two
>> "superaliases" ?
>>
>
> As you pointed out, I can create a database for each year for the next
> hundred years.
No. I talk about *aliases* not databases.
> Doubtful, but theoretically possible. Even that won't fill up
> the directory because the data doesn't grow nearly as fast as hard drive
> space does.
>
> However, it would be useful, IMO, to have an alias for directories so that
> conceptually, you could separate entire functionalities. For instance, the
> main databases reside in an alias directory called MainDataDir. Backups
> could be performed to the BackupDataDir.
aliases for backup files ? Oh...
> User importing/exporting of data
> could be in a shared directory known as UserDataDir.
Seems you want that Firebird implement solution for your applied issue.
> Changing the location
> of these would become much easier just like it is now with database aliases.
Let me guess how you going to use this super-aliases :
a) create entry at aliases.conf for common folder for historical databases :
databases = c:\archive\databases
b) Application have built-in (or configurable) knowledge about this super-alias
c) Application want to work with database of year NNN. It should open it as
databases:yearNNN
d) in Year 2015 space on disk C: is over and you want to add second
super-alias, say
databases2 = d:\archive\databases
e) Aplication should be changed to take it into account !!!
If you pre-create *aliases* for databases :
year2010 = c:\archive\databases\year2010.fdb
year2011 = c:\archive\databases\year2011.fdb
year2012 = c:\archive\databases\year2012.fdb
year2013 = c:\archive\databases\year2013.fdb
year2014 = c:\archive\databases\year2014.fdb
year2015 = c:\archive\databases\year2015.fdb
year2016 = c:\archive\databases\year2016.fdb
and at some point of time you are out of disk space on drive C, all you need to
do is
to change few aliases and don't touch application :
year2015 = D:\archive\databases\year2015.fdb
year2016 = D:\archive\databases\year2016.fdb
Regards,
Vlad
------------------------------------------------------------------------------
Benefiting from Server Virtualization: Beyond Initial Workload
Consolidation -- Increasing the use of server virtualization is a top
priority.Virtualization can reduce costs, simplify management, and improve
application availability and disaster protection. Learn more about boosting
the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
