Firebird - Data Blobs

	Forums Register Login My Profile Inbox Address Book My Subscription My Forums Member List Search FAQ Ticket List Log Out

Firebird - Data Blobs

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [Archiving & Fax] >> GFI MailArchiver >> Firebird - Data Blobs

Page: [1]

Message

<< Older Topic Newer Topic >>

Firebird - Data Blobs - 26.Oct.2007 1:00:23 PM

moon1234

Posts: 36
Joined: 22.Oct.2007
Status: offline

I would like to know if data blob support is planned for Firebird? This would allow all archived e-mails to be stored in the firebird database instead of in hundreds of thousands of individual files on the hard drive. This would make backups and restores of the archived e-mail MUCH faster.

I also seem to have found a bug. The ampersand (&) character cannot be used as part of search string when searching through the mail archive. It does not matter if the ampersand is enclosed in quotes or not. The search will not return any results if an ampersand is included anywhere in the search string. We would like this functionality as our accountants would like to be able to search based on bank names. M&I bank is one search they would like to be able to save as a search folder.

Thanks!

Post #: 1

RE: Firebird - Data Blobs - 29.Oct.2007 9:54:23 AM

Rodion

Posts: 834
Joined: 15.Nov.2004
Status: offline

Hello

Unfortunately Firebird is not as reliable as SQL server when it comes to the databases larger then 10 GB. Plus you can see a general performance degradation. Therefore it was decided to keep the emails outside of the database.

GFI MailArchiver 5 (available in Beta now) introduces a Microsoft Volume Shadow Copy (VSS) support that allows you to use a compatible backup software to make very efficient backups of the Firebird databases and indexes on the fly.

Thank you for reporting the search issue. We will be looking into this. For now I can suggest using a space (" ") character instead of the "&" in the searches.

_____________________________

Best regards

Rodion Denisyuk
GFI Software Ltd

(in reply to moon1234)

Post #: 2

RE: Firebird - Data Blobs - 18.Sep.2009 11:19:42 AM

charlesw

Posts: 12
Joined: 31.Jan.2008
Status: offline

Has there been any progress on the ampersand issue? This seems like somewhat of a critical oversight.

(in reply to moon1234)

Post #: 3