logo logo

 Back to main page

The NWNX Community Forum

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
MS SQL Remote Blob Store Feature

 
Post new topic   Reply to topic    nwnx.org Forum Index -> Database related
View previous topic :: View next topic  
Author Message
chris421



Joined: 07 Apr 2005
Posts: 53
PostPosted: Mon Feb 09, 2009 22:27    Post subject: MS SQL Remote Blob Store Feature Reply with quote
Ran across this looking for something completely unrelated in the feature pack.

Sounds right up NWNX's alley. I recall MS SQL object storage issues after x bytes.

Can't remember if one of you guys resolved it, or just gave up.

Quote:

SQL Server Remote Blob Store
The SQL Server Remote Blob Store is a method for storing blobs of unstructured data in an external Content Addressable data store. The component consists of a client-side DLL that is linked into a user application, as well as a set of stored procedures to be installed on SQL Server. Run the self-extracting download package to create an installation folder. The setup program contained there will install RBS on X86, X64, and Itanium-based computers.

Audience(s): Developer, DBA


X86 Package (RBS.msi) - 3584 KB
X64 Package (RBS.msi) - 4648 KB
IA64 Package (RBS.msi) - 7039 KB



http://www.microsoft.com/downloads/details.aspx?FamilyID=228de03f-3b5a-428a-923f-58a033d316e1&displaylang=en
Back to top
View user's profile Send private message
Gryphyn



Joined: 20 Jan 2005
Posts: 431
PostPosted: Tue Feb 10, 2009 8:36    Post subject: Reply with quote
Yep, solved it!
That was an ODBC API issue (for SQLServer) - 0xFFFFFFFF = check for more data, not 4294967295 bytes

No, what you've found is an app to store BLOBs outside of the database structure. The new improvements are in the STREAM tech that delivers your BLOB to the application. It's the combination that gives you the true benefits - BLOB data goes through the System Cache, without filling the Database Buffers.

Cheers
Gryphyn
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Database related All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group