You are provided with a legacy Python script that processes CSV files sequentially. The script reads from a directory, processes each row using a CPU-bound function, and writes results to a database. The current implementation is slow and blocks the main thread. Analyze the provided code, identify bottlenecks, and refactor it to use asyncio for I/O-bound operations and multiprocessing for CPU-bound tasks. Ensure the solution handles exceptions gracefully, maintains the order of results, and includes a detailed explanation of the concurrency model used.