Its not indexed properly ...

What is preventing you from indexing it properly? Even if you do decide to split it up, you shouldn't have to dump the table. And if you do go the XML route, then XML::Twig or XML::Rules.