[firebird-support] Re: database in external USB HDD
2) Pen Drive : more compact. Welcome to our recovery service :) Yes, Pen Drive is really not reliable, prepare to lost you data if you using this media, that why I said USB Hardisk is more reliable compare to Pen Drive :) 3) RAM Disk : highest speed but risky and less space. Do not use it unless you aware of the risk. Runs on a dedicated PC (no other programs run on this pc, only database server and OS), backup it everyday, twice a day and have a reliable UPS. Love the speed when doing maintenance (backup/restore) - superb compare to those two. We have tested RAM Disks - no performance advantages found when comparing to the properly tuned Firebird. Strange, I have a sample database that showing the speed when backup/restore in RAM Disk is much more faster compare to disk, about 20 or 30 times faster perhaps, may be my Disk is too slow, it is SATA II anyway :) About performance, assuming same database (one on the RAM and the other on the disk), I think it has something to do with database cache memory. If most of data can fits in cache memory, of course, no performance gain since both processing took place on RAM. incendio.
[firebird-support] Re: database in external USB HDD
I use FB 2.01 in external USB drive connected to the server for about 3-4 years. No problem at all, I think FB 2.5 won't be a problem too. Currently, using FB 2.5 on a RAM Disk (in server) for a better speed. Thanks for the answer!! If memory serves, I think I read somewhere a post from Helen Borrie in which she says that is not a good idea... But can't find that post now! :( Thanks again! sergio
Re: [firebird-support] Re: database in external USB HDD
Are you sure you are not mixing it with using the database on Pen Drives ? Em 4/7/2012 19:10, Sergio escreveu: I use FB 2.01 in external USB drive connected to the server for about 3-4 years. No problem at all, I think FB 2.5 won't be a problem too. Currently, using FB 2.5 on a RAM Disk (in server) for a better speed. Thanks for the answer!! If memory serves, I think I read somewhere a post from Helen Borrie in which she says that is not a good idea... But can't find that post now! :( Thanks again! sergio ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links
[firebird-support] Re: database in external USB HDD
Are you sure you are not mixing it with using the database on Pen Drives ? Hi Alexande! thanks for the answer! May be... I'm not sure... But in any case, what would be the difference in having the database file on an USB HDD and a Pen Drive? Or it's just a matter of space or performance? Sergio
[firebird-support] Re: database in external USB HDD
On my experience : 1) USB HDD : more reliable, more speed and more space. 2) Pen Drive : more compact. 3) RAM Disk : highest speed but risky and less space. Do not use it unless you aware of the risk. Runs on a dedicated PC (no other programs run on this pc, only database server and OS), backup it everyday, twice a day and have a reliable UPS. Love the speed when doing maintenance (backup/restore) - superb compare to those two. Incendio. --- In firebird-support@yahoogroups.com, Sergio shg_sistemas@... wrote: Are you sure you are not mixing it with using the database on Pen Drives ? Hi Alexande! thanks for the answer! May be... I'm not sure... But in any case, what would be the difference in having the database file on an USB HDD and a Pen Drive? Or it's just a matter of space or performance? Sergio
Re: [firebird-support] Re: database in external USB HDD
Hello All, To let you know our opinion (from the point of view as recovery products and services company): On my experience : 1) USB HDD : more reliable, more speed and more space. USDB HDD can be used only for backups. Database should be on RAID1/5/10 (according to your budget). 2) Pen Drive : more compact. Welcome to our recovery service :) 3) RAM Disk : highest speed but risky and less space. Do not use it unless you aware of the risk. Runs on a dedicated PC (no other programs run on this pc, only database server and OS), backup it everyday, twice a day and have a reliable UPS. Love the speed when doing maintenance (backup/restore) - superb compare to those two. We have tested RAM Disks - no performance advantages found when comparing to the properly tuned Firebird. With best regards, Alexey Kovyazin IBSurgeon www.ib-aid.com [Non-text portions of this message have been removed]
[firebird-support] Re: database in external USB HDD
I use FB 2.01 in external USB drive connected to the server for about 3-4 years. No problem at all, I think FB 2.5 won't be a problem too. Currently, using FB 2.5 on a RAM Disk (in server) for a better speed. incendio. --- In firebird-support@yahoogroups.com, Sergio H. Gonzalez shg_sistemas@... wrote: Hello there! I use FB 2.5. Is there any known problem with having the database file in an external USB drive conected to the server? Just in case (don't know if it matters!) I always use superserver mode. thanks!! -sergio [Non-text portions of this message have been removed]