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 
 
Problem Retrieving Large Objects

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



Joined: 16 Jun 2007
Posts: 25

PostPosted: Wed Aug 05, 2009 1:22    Post subject: Problem Retrieving Large Objects Reply with quote

I'm hoping somebody can help me out here. I'm trying to convert a storage system from SCO/RCO to NWNX's SPO/GPO. I've stumbled upon a problem though. Large objects (greater than 1 MB) are not retrievable. The object stores just fine but when the 'Get' is made, the object does not appear. SPO/GPO works fine for smaller objects.

Does anyone have a clue what might be happening to the large objects on retrieval?

Thanks,
JP
Back to top
View user's profile Send private message
virusman



Joined: 30 Jan 2005
Posts: 1020
Location: Russia

PostPosted: Wed Aug 05, 2009 8:00    Post subject: Reply with quote

What's the field type you're saving the object data to?
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
PhyrPhly



Joined: 16 Jun 2007
Posts: 25

PostPosted: Wed Aug 05, 2009 18:45    Post subject: Re: Problem Retrieving Large Objects Reply with quote

The field in the DB is LARGEBLOB. The object stores fine. I can view the data in the database just fine.

Other possibly useful information is...
I am using MySQL Database on Windows.
I am using Windows version NWN and NWNX. I haven't yet tried to see if the issue presents itself with the linux versions.

JP
Back to top
View user's profile Send private message
Zebranky



Joined: 04 Jun 2006
Posts: 415

PostPosted: Wed Aug 05, 2009 23:06    Post subject: Reply with quote

You may want to try the build of nwnx_odbc at http://mercuric.net/nwn/nwnx/nwnx_odbc-20090624.dll. It's linked against a newer version of libmysqlclient than the one on nwnx.org, and it has fixed more than one person's issues.

If that doesn't work, I'd try changing the field type to BLOB, as that's what I've always used.
_________________
Win32 SVN builds: http://www.mercuric.net/nwn/nwnx/

<Fluffy-Kooshy> NWNx plugin is to this as nuclear warheads are to getting rid of fire ants.

<ThriWork> whenever I hear nwn extender, I think what does NWN need a penis extender for?
Back to top
View user's profile Send private message Visit poster's website
PhyrPhly



Joined: 16 Jun 2007
Posts: 25

PostPosted: Thu Aug 06, 2009 0:34    Post subject: Re: Problem Retrieving Large Objects Reply with quote

Zebranky wrote:
You may want to try the build of nwnx_odbc at http://mercuric.net/nwn/nwnx/nwnx_odbc-20090624.dll. It's linked against a newer version of libmysqlclient than the one on nwnx.org, and it has fixed more than one person's issues.

If that doesn't work, I'd try changing the field type to BLOB, as that's what I've always used.

Thanks for the link. I tried with that build but received the same result. As for using the BLOB data type, if I remember correctly, BLOB is only good for about 16KB of data. The objects I'm trying to store would routinely exceed that.

For what it's worth, I have loglevel set to 4 and receive no errors.

JP
Back to top
View user's profile Send private message
Zebranky



Joined: 04 Jun 2006
Posts: 415

PostPosted: Thu Aug 06, 2009 10:47    Post subject: Reply with quote

http://www.mysql.com/news-and-events/newsletter/2003-09/a0000000237.html is several years old, but indicates that the theoretical limit is 2GB and the practical limit is hundreds of MB. I did find some sources that stated 64K, but from what I read I'm inclined to say it scales as needed.

I have to wonder what you could possibly be doing that requires storing objects over 1 MB, but...
_________________
Win32 SVN builds: http://www.mercuric.net/nwn/nwnx/

<Fluffy-Kooshy> NWNx plugin is to this as nuclear warheads are to getting rid of fire ants.

<ThriWork> whenever I hear nwn extender, I think what does NWN need a penis extender for?
Back to top
View user's profile Send private message Visit poster's website
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