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
The question about storing XML in dbf and mysql
Moderator: Rathinagiri
- nguyenchiduc
- Posts: 78
- Joined: Sat Nov 13, 2010 7:27 am
- 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
Yes, you can do that.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.