> The flashcards are around a million in number, organised into 19 subjects, 5-10sections each, 10-20chapters under each section and several subtopics under each chapter.

I am not sure whether Sqlite scales, but that would be my first suggestion.