Re: Re: Re: Data structure advice

The nice Perl trick is a SQL trick. And, don't write the function - it's already written! Use the tools you have. Plus, once you have it in a database, you're going to find other capabilities. Trust me.

------
We are the carpenters and bricklayers of the Information Age.

Please remember that I'm crufty and crochety. All opinions are purely mine and all code is untested, unless otherwise specified.

Comment on Re: Re: Re: Data structure advice

Replies are listed 'Best First'.
Re: Re: Re: Re: Data structure advice by robinbowes (Beadle) on Jan 05, 2004 at 15:25 UTC
Hi, I am aware of the capabilities of using SQL, but feel that it is overkill for this application. I will have, at most, 48 pressure values per day to look up; these will be read from a .csv format file. I could, I agree, use DBI (I think DBD::CSV would be most appropriate) but I can't help thinking that the performance overhead will be too much. I suppose I could always just try it, i.e. profile rather than speculating. I'll wait to see if there are any other suggestions then knock something up tomorrow. Cheers, R. -- Robin Bowes \| http://robinbowes.com	[reply]

Replies are listed 'Best First'.

Re: Re: Re: Re: Data structure advice
by robinbowes (Beadle) on Jan 05, 2004 at 15:25 UTC

Hi,

I am aware of the capabilities of using SQL, but feel that it is overkill for this application.

I will have, at most, 48 pressure values per day to look up; these will be read from a .csv format file. I could, I agree, use DBI (I think DBD::CSV would be most appropriate) but I can't help thinking that the performance overhead will be too much.

I suppose I could always just try it, i.e. profile rather than speculating.

I'll wait to see if there are any other suggestions then knock something up tomorrow.

Cheers,

Robin Bowes | http://robinbowes.com

[reply]