i wanted to use ‘activerecord-import’ for bulk import but i have dependent tables.
if i insert in one table then two more tables have to be inserted with the foreign key. can i use activerecord-import in this case.
the database structure would be like:
a product table with a product_details table having a one-to-one relationship
and a product_index table having some selected columns from product, product_details table to make indexing and pagination faster.
another table having a counter_cache to make pagination easier.
so any inserts for products will be split into the product and product_details table, with some selected information being inserted into product_index table.