Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Perl > Reading data out from different files

Reply
Thread Tools

Reading data out from different files

 
 
Mario Fischer
Guest
Posts: n/a
 
      10-15-2003
Hi!

I wrote a small SQL-parser for SELECT-statements for the purpose of
easier switching between databases. The parser also works with
multiple-table-queries.
Until here everything is fine, but when I try to read out the
information from flatfiles I get in trouble.
An example: I'm reading all columns of 2 tables and I want to search
for something defined in the WHERE-statement. For example I want to
manage user-sessions in a control-panel and want to find out more
about the user-id in the sessions-table that belongs to a user-name in
the user-table.
In Perl I would read the content of the tables into a hash and in the
worst case I have to compare each line from the one table with all
lines from the other one. That is very unefficient.

Is there a better solution (maybe someone knows how this problem is
solved in mySQL)?

Thank you.

Mario
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Reading data from 2 different files and writing to a single file Chris Angelico Python 0 01-28-2013 02:49 PM
Re: Reading data from 2 different files and writing to a single file Dave Angel Python 0 01-28-2013 02:37 PM
Re: Reading data from 2 different files and writing to a single file Chris Angelico Python 0 01-28-2013 02:19 PM
Re: Reading data from 2 different files and writing to a single file Dave Angel Python 0 01-28-2013 02:05 PM
Re: Reading data from 2 different files and writing to a single file Chris Angelico Python 0 01-28-2013 01:43 PM



Advertisments