Is it Possible to reduse memory by converting file to bytes and store it on MS Access database

Question

1.00/5 (2 votes)

See more:

sir.. if i am asking Absurdity pls forgive me...
i am trying to make an c# window form applicaion. application converts files(mp3,jpg,png..etc..) into its coresponding byte code format and stored in ms Access database and vise versa. i heard that ms Access file is portable. is it posible to convert back in another system using the same app?? i think it can reduse memory a lot... is it possible...??? i need your help to continue... thanks...

Posted 11-Feb-14 8:56am

JeseemRazak619

Updated 11-Feb-14 9:42am

v2

Add a Solution

Comments

Philippe Mori 11-Feb-14 19:02pm

Effectively, I think it is mainly absurd to do that...Use the original file. Most format are already compressed so you usually won't be able to gain much space even if you try to compress the files.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2014-02-11T09:03:00

Solution 1

You can do it...but...it won't save anything useful - it will probably use more disk space rather than save it, and slow down access to the data.
Base64 is not a compression technique, it's a "safe transport" encoding: it converts hex bytes into a character based system, where each 5 bits of the input takes up 8 bits of the output. As a result, the output data is going to be 1/3 bigger than the input...

Access can hold binary data without translation - but even then I wouldn't store large files as it complicates storage and makes the DB a lot harder to back up.

What are you trying to achieve that you think this would be a good and necessary idea?

Posted 11-Feb-14 9:03am

OriginalGriff

Comments

JeseemRazak619 11-Feb-14 15:25pm

when i try to convert an image file into byte and save it as .txt format... it takes time but the size of file is too small... then i try the same with sql database. it perform good but i dont know what's the size of file and also its not portable na... thats why i am trying to do this with MS Access

OriginalGriff 11-Feb-14 15:49pm

What on earth makes you think Access is more portable than SQL Server?
I can use SQL Server from my Android tablet, and there is no version of Access that will do that!

Perhaps your code was wrong?

JeseemRazak619 11-Feb-14 15:53pm

sir i want to transfer the database file using a pen drive or something like that. is it posible with sql

Philippe Mori 11-Feb-14 19:04pm

Transfer the original files... or maybe put the file into a ZIP. Usually it is more convenient to use original files directly.

JeseemRazak619 12-Feb-14 4:31am

yes.. i am trying to zip the MS Access file..

OriginalGriff 12-Feb-14 4:35am

Please!
First off, JPG, PNG and so forth don't zip well: they are already compressed formats, as are video files, and many other types.
And why encapsulate a set files in a different format (which adds a considerable overhead) just to zip that file (which adds more overhead)?
Just zip them directly, and save the ZIP file to the pen drive - it will be the most efficient method in space terms.

JeseemRazak619 12-Feb-14 4:42am

ok... thank you sir.