Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: How to Split on specific occurrence of a comma

by NetWallah (Canon)
on Dec 04, 2020 at 04:28 UTC ( #11124623=note: print w/replies, xml ) Need Help??


in reply to How to Split on specific occurrence of a comma

IMHO - instead of adding the complexity of batching with artificial limits, my proposal is:

use a temporary table to store the list of things you are looking for.
Then let the DB do the work of intersecting the 2 tables.

This is no longer subject to memory or list-size limits, and is likely better optimized by the db engine.

                "Imaginary friends are a sign of a mental disorder if they cause distress, including antisocial behavior. Religion frequently meets that description"

  • Comment on Re: How to Split on specific occurrence of a comma

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11124623]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (1)
As of 2021-10-23 11:15 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My first memorable Perl project was:







    Results (88 votes). Check out past polls.

    Notices?