The question about storing XML in dbf and mysql

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

Post Reply
User avatar
nguyenchiduc
Posts: 78
Joined: Sat Nov 13, 2010 7:27 am

The question about storing XML in dbf and mysql

Post by nguyenchiduc »

The question about storing XML in dbf and mysql

I have 140000 XML files. Each file size is about 5-10k. It mean 140000x5-140000x10 k, Approximately 685M - 1.3G
I want to store 140000 records on dbf and mysql. Each record has a customer ID to search by index
Use HMG on my PC to manipulate dbf and sync updates with mysql on website. Mysql to serve customers search on the website
Only show one result (record) for each search because of Customer ID and Time. Then download to XML

Can I do this with Apache + PHP + Mysql on the Web Server? If not, what should I do?

Thanks to the creator of HMG and everyone who maintains hmgforum for a very long time
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: The question about storing XML in dbf and mysql

Post by Rathinagiri »

Yes, you can do that.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
Post Reply