Re: getting one line from file

Okay, what's the problem?!! You export all the data once to your sql server, [even with a simple perl or php script], then change the script [on the other machine] which alters the text file. In the part which changes the text file and adds new information to the file, you open a connection to the other machine [which had the text file and now has the sql server on it] and trough that sql connection, add new rows to your database. Searching trough that database is quite faster and easier! I bet it doesn't put more load on your system. :-) [Use MySql if you're using php, it's the ultimate]. regards, Ahmad Anvari > > Hey pac, > > i suggest you to export all your information into a sql > > server. This amount of data is really big to be stored > > into a text file!! :) > > Ahmad Anvari > > > yes yes yes...i think i have 20 mail messages from people saying to do > this...i would if i could, the problem is this data is changing all the time > and being copied from another machine to the webserver. therefore i would > have to either reload the database each time the data changed or determine > what has changed each time it is copied and then modify the sql > databases....which i believe either way would be a bigger load on the > system. >