internal server error?

Question

Hello I have a php script that selects zip codes finds their distances from each other and then stores those zips that are 10/20/50/100 miles away from each other.
To start this script was taking around 4 mins to store 500 zips. However as the database size has increased the time to execute the script slowed.

I have completed 10’000 of the zips, and the databse is now 40Mb in size. However now when I try and execute the script it takes around 10 mins to store just 20 zips, and I get an internal server error.

I have checked my php.ini and everything to do with mysql is to the max, so I can’t see why it is coming up with this.

I have tried to save the database using export however it tries to save for about 5 mins and again I get the internal server error.

Again this is only to do with the size of the database as I am able to export smaller databases.

Does anyone know how I can firstly get my script to speed up again and secondly how to get it to save larger databases.

Hey abatardi, i am happy to email you the code, but you have the email function turned off. Thanks for the response though.

Answer 1

it's most likely a database design flaw, but it could be code related too. I'm not sure what you mean by saving using export... what type of database are you using? 40mb is a tiny database, so it shouldn't be a problem.

If you want, email me and I can probably help, but I would most likely need to see your DB and code to give you an answer so it's up to you. :-/

Answer 2

I played a little with my jailbroken ipod and found out either two things 1. Servers too busy,not allowing you to download or 2.This worked, in the begging your given a security thing a word if you put it in incorrect it says the 500 error but if you do it correct it will take you to fileape , dude and then you have to get filedude correct or else it will say error 500, in other words get the security thing right , this solved my problem hope it helps.