View previous topic :: View next topic |
Author |
Message |
PhyrPhly
Joined: 16 Jun 2007 Posts: 25
|
Posted: Wed Aug 05, 2009 1:22 Post subject: Problem Retrieving Large Objects |
|
|
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 |
|
|
virusman
Joined: 30 Jan 2005 Posts: 1020 Location: Russia
|
Posted: Wed Aug 05, 2009 8:00 Post subject: |
|
|
What's the field type you're saving the object data to? |
|
Back to top |
|
|
PhyrPhly
Joined: 16 Jun 2007 Posts: 25
|
Posted: Wed Aug 05, 2009 18:45 Post subject: Re: Problem Retrieving Large Objects |
|
|
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 |
|
|
Zebranky
Joined: 04 Jun 2006 Posts: 415
|
Posted: Wed Aug 05, 2009 23:06 Post subject: |
|
|
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 |
|
|
PhyrPhly
Joined: 16 Jun 2007 Posts: 25
|
Posted: Thu Aug 06, 2009 0:34 Post subject: Re: Problem Retrieving Large Objects |
|
|
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 |
|
|
Zebranky
Joined: 04 Jun 2006 Posts: 415
|
Posted: Thu Aug 06, 2009 10:47 Post subject: |
|
|
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 |
|
|
|