There is an application generating the files for mass printing out of our billing system once a week. Actually it is not 100K but 500K at once per week! While...

Thanks guys. I think this temp file solution is the way to go.

But do you have any idea how to store about 100 000 files at once into the database...

Sure. But is it a real life scenario?

I mean why would you use the same sequence (value) in several table.

IMHO, but I may be wrong, a unique identifier or a counter...

But my issue is how to insert over 100 000 images at once into the database with a decent performance?

And what I don't know is how to show a PDF...

Chung,

A (secondary) covering index is an index where all columns are included which are part of your query (in the join, where and select, order by... clause)

To make your query efficient...

I personnaly prefer SQLServer's Identity to Oracle's (DB2's, PGSQL's...) sequence. Because a sequence is an "external" object to a table, what you have to create separatly, while SQLServer's identity is...

You have to redefine your datatypes. Collation is not enough because if a column is defined char(8), varchar(8)... it means max. 8 single bytes (characters) will be stored regardless of the...

Also you have to enable the /3GB switch within your boot.ini file so the operating system will only use 1 GB for it's use

The users want only to see those images.

My customer is a utility company having 2.3+M customers. They want to store the image of the invoices they are generating in a...

By seeing this limitation I will clearly shoot for the file system storage!

At worst case I will create files within some containers (like zip files) which hold several images.

Thanks guys!

Andrew,

The basic idea is the list every items of your main table (analgroup) and optionally the records ot other tables by LEFT joining them

Do you have AWE enabled?

There is an error in the SP4 regarding the AWE.

Unless there is a commercial tool I would suggest to write your test tool by yourself in your preferred programing language (C, C++, C#, Delphi...)

You have to define the transaction...

Just to avoid all the mess with all different formats at the beginning you could convert all the documents into a common format, like PDF, or JPG or TIFF.

After that...