beersa wrote:
Hi All,
I have to query the database with the string from text file. Here are
the details:
OS: WinXP Home Pro
DB: Oracle 9.x
The table in DB has 20,000 rows. The text file has 15,000 rows. I wrote
a program and read the string from text file and run SELECT query in DB
to look for the string. The program read line by line. That mean, For
each line the SELECT query is running, i.e. 15,000 times.
I use Streamreader class to read the text file and OracleDataReader
class to query the database.
Can anyone suggest me the better approach or design?
Thanks & Regards,
BeerSa
Beersa, at the risk of starting a barrage of complaints regarding
Portability/Compatibility and cries of "It's just not done that way",
have you ever thought of Rolling Your Own? By this I mean writing your
own Binary File Access method and reading the Oracle database records
without using any database engine.
If you're looking for speed then nothing will beat it!
I've often done this for clients who want VERY, VERY fast access to
information embedded in large databases. Using this type of method will
open the opportunity of reading, and scanning, tens-of-thousands of
records per second and locating the text you require faster than
anything you've probably ever seen before.
Just my thoughts.... You did ask for the "Fastest String Search"!!!
ShaneO
There are 10 kinds of people - Those who understand Binary and those who
don't.