inside the request_content I strore the content of the request as XML document, I have more than 100 request type and based on that I have more than 100 XML structure.. for example this is a snippit of Flyer Printing Request:
I havn't started writing the code. I am still in the desgin stage and trying to figure out the best practices so I am not sure either to use DOM or other means. I'll be pulling many records at a time I think since I'll be searching the whole table.. I'll be using PHP+MySQL.