What is the best way to save a large array in database? Currently, I'm working on a simple CBIR (Content-based Image Retrieval) and I have a question.

What is the best way to save a large array on the database? For example, I want to save the results of Canny or GLCM (Gray-level Co-Occurrence Matrix) which is very large.

Also, if someone knows about Image Retrieval techniques, Please tell me is it a good way to save all of the information which mentioned algorithms produced for comparison or not? If it's not, so what is a good way?

Thanks.
It depends on where the data is coming from:


If you do not have a .NET application and you do have the data in a text file, then you can use the BCP.exe utility.
If you have a .NET application, then my preference would be to use a Table-Valued Parameter (TVP). I have an example of one (with .NET / C# and T-SQL code) in the following Stack Overflow answer:

How can I insert 10 million records in the shortest time possible?