Re: Checking the length of all row elements
[email protected] (Alexander Foken)
| Newsgroups | perl.dbi.users |
|---|---|
| Message-ID | <[email protected]> |
What's wrong with all the answers you got to exactly the same question at perlmonks.org <URL:http://perlmonks.org/?node_id=851194>? Alexander On 24.07.2010 21:17, Parag Kalra wrote: > I have a requirement where I need to check the length of each row of all the > columns of my table. > > I was planning to use following algorithm > > 1. Get the data from the table using DBI and store it in file > 2. Split the each row using the delimiter and store it in array > 3. Loop the through the array and check the length > 4. Repeat this step for all the rows. Thus Parse the file row by row > > But to me this might be slow process since we would be processing each and > every element of the table. > > Is there any better optimized solution. > > Cheers, > Parag > > -- Alexander Foken mailto:[email protected] http://www.foken.de/alexander/