Re^8: how to define key for a hash

let me explain my work flow it may help in a better way. I have a set of calldetails which is coming to my system unix file area which needs to be lookup with the incoming phone numbers and replace a perticular value in the call details file and then use our core api to calculate the rate of call and upload to our database. So my intension is to do the lookup before the call rates are getting calculated.since my sore api which calculates the rate can only identify input as flat file,so i have to get the file as flat file after this lookup. So how can i bring database in b/w these? that y i thought of a perl script which can do the lookup activity whose performance is comparable with database. But since this perl is very new to me..i am really confused and am not getting any encouraging reply from this site also.... I have alreadt done this logic with sql loader and shell scripting ,but im not quite satisfied with the performance.That y i turned to perl.....

Comment on Re^8: how to define key for a hash

Replies are listed 'Best First'.
Re^9: how to define key for a hash by Corion (Patriarch) on Jun 26, 2009 at 07:49 UTC
Again, we cannot help you with your data analysis. If you have programmed your loading with SQL Loader and shell scripting, you should have a rough idea of what the Perl program needs to do. Perl will likely never beat SQL Loader for speed of data loading, but it might be faster for preparing the data than your shell script is. For querying the data, it still depends on your hardware, your network, the queries and the amount of data and calculations that need to be done. We cannot help you there.	[reply]

Replies are listed 'Best First'.

Re^9: how to define key for a hash
by Corion (Patriarch) on Jun 26, 2009 at 07:49 UTC

Again, we cannot help you with your data analysis. If you have programmed your loading with SQL Loader and shell scripting, you should have a rough idea of what the Perl program needs to do. Perl will likely never beat SQL Loader for speed of data loading, but it might be faster for preparing the data than your shell script is.

For querying the data, it still depends on your hardware, your network, the queries and the amount of data and calculations that need to be done. We cannot help you there.

[reply]