The table in DB has 20,000 rows. The text file has 15,000 rows. I wrote

> Are you doing this one time? Once a day?

> Do the contents of the text file change? Are more lines appended to it or
> do you get an entirely new file?

> Does it contain words or phrases? Are you looking for exact matches or
> substring searches?

> Can you import the text file into a table and perform a SQL query against
> the table?

> What do you need out of the process? Another text file, a report, an
> updated DB?

> And finally, is there a business requirement that limits the amount of time
> it can take and/or the format of the DB and text files?

> Are you doing this one time? Once a day?

> Do the contents of the text file change? Are more lines appended to it or
> do you get an entirely new file?

> Does it contain words or phrases? Are you looking for exact matches or
> substring searches?

> Can you import the text file into a table and perform a SQL query against
> the table?

> What do you need out of the process? Another text file, a report, an
> updated DB?

> And finally, is there a business requirement that limits the amount of time
> it can take and/or the format of the DB and text files?

"beersa" <sabeer.sabeer@gmail.com> wrote in message
news:1164944186.467570.201090@n67g2000cwd.googlegroups.com...
> 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" <sabeer.sabeer@gmail.com> wrote in message
news:1164949161.363729.174410@f1g2000cwa.googlegroups.com...
> Thanks Tom for your prompt response.
>
> I would like to give you more details on this.
>
>> Are you doing this one time? Once a day?
> Few times only. For some data mapping tasks.
>
>> Do the contents of the text file change? Are more lines appended to it
>> or
>> do you get an entirely new file?
> The text file is fixed-size word length and it is entirely new file.
>
>> Does it contain words or phrases? Are you looking for exact matches or
>> substring searches?
> It is fixed size words. Looking for exact matches in database. So, the
> search string from the text file.
>
>> Can you import the text file into a table and perform a SQL query against
>> the table?
>
>
>> What do you need out of the process? Another text file, a report, an
>> updated DB?
> Output is text file.
>
>> And finally, is there a business requirement that limits the amount of
>> time
>> it can take and/or the format of the DB and text files?
> There is no Business requirements .
>
> Hope you can assist me.
>
> Regards,
> Sabeer
>

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
>