Which multimedia database can be used with VB.NET
i am working on a project "criminl records system,
i want to add criminals picture in my form,database,which database can used with this VB.NET application.plz specify how can i connect with my form...
Software/Hardware used:
Software/Hardware used:
ASKED:
April 7, 2009 10:26 AM
UPDATED:
April 14, 2009 11:46 PM
Answer Wiki:
You can use SQL Express or MySQL seen that these are the most frequently used ones and support images but I suggest you the Microsoft one. For connection try and Google it or refer to <a href="http://www.homeandlearn.co.uk/NET/nets12p4.html">this simple tutorial</a>.
To see all answers submitted to the Answer Wiki: View Answer History.
It is most common and recommended that you store the images on a file server and not in the database, simply storing a pointer to the file within the database. When you store the images within the database the database has to perform a lot more disk IO than it should to retrieve and store the images. This prevents the database from doing other things while it gets the images.
As the database grows (there are always more criminals being added) the problem will get worse and worse and you’ll eventually need to make the change anyway.
(This doesn’t matter what database platform you use.)
I agree with Mrdenny.
Also, storing the images in the database will make the database size bigger, and some versions/databases (such as the express editions) use to have some size restrictions.