benf — Wed, 14 Sep 2005 12:51:58 +0000

This is the site g-aa.co.uk

I bought the software to run this site and as part of the set up it uses delimited file databases. I want to migrate my website to another host because my current host is american and i would prefere to have it hosted in britain. Plus i would like cpanel on my hosting account simply because i find it easy to manage everything with.

I copyed and pasted files onto a subdomain g-aa.globalimagehost.com to test it out but it is not working.

Any suggestions?

Your previous replys have been very helpful i might add.

Thanks.

JeevesBond — Wed, 14 Sep 2005 00:11:29 +0000

Greg's absolutely right benf, I'm a little confused by exactly what his new host of yours is offering. Most offer a fully fledged RDBMS like MySQL, Postgre etc all of these are a lot faster than flat file for sorting, retrieving and performing aggregate functions.

As said: It's a bit bizarre they're not providing a proper DB solution.

Greg K — Tue, 13 Sep 2005 21:44:32 +0000

Without seeign the actual setup, I'd say you are pretty safe there, as long as the new hosting company uses the same scripting language you are currently using (PHP, ASP, etc). May also want to compare versions.

The speed issue, that would depend. if you are not updating and needing to grab all the records, then flat file is probably faster. But one you start edit/removing records or if you are only needing to get say 5 of 2000 rows, then a true database would be better. (IMO) A database will most likely do sorting, filtering and other function much faster than your scipt will, so with a database, you are given the results.

(this is also why in general you should have the database do as much processing as possible before getting the results, ie, getting totals, merging data, calculations, etc)

-Greg