Hello, I have a general question about dealing with databases.
I'm working on an IR system, and in the parsing phase we need to store words from one document into the database. Is it better to open a connection for storing each word, or maybe I should open a connection at the document level,taking into consideration the database security issue.
Reid M. Pinchback
posted 11 years ago
Estimate the number of words in your document. Use a rough estimate of the time to open and close a connection. Multiply the two numbers, and you'll have the overhead of getting connections on a per-word basis. Probably won't take very many words before you'll find the overhead to be excessive.