perl and caches

From the perl DBI manual page:

If you’d like the cache to managed intelligently, you can tie the hashref returned by “CachedKids” to an appropriate caching module, such as Tie::Cache::LRU

And what happens when I don’t do this? Will my cache be unintelligently managed then, with the consequence of my machine exploding when the cache is filled with more than a handful entries?