Depending on what your ServiceBuilder service does upon writing such
an entry, you have different options:
If you don't need any Liferay infrastructure (as
ResourcePermissions), you can actually write directly to the
custom tables, (NEVER do that for build-in tables).
Especially when it's INSERT operations (as opposed to UPDATE): They
won't be in the cache anyway, and you'll not need to take care of the
cache. However: Careful with ID generation - don't cause duplicate ids later.
You certainly want to batch the inserts into smaller chunks, to not
end up with a humongous transaction. (this naturally also means that
you'll need to think about retry options)
And, of course, you likely don't want to read a file of that size
into memory before starting to process it, but operate on the current
line, or another smaller chunk of the file at a time.
Last but not least: Sometimes raising the memory limit is a nice
quick fix for such an operation
What's best? You judge
