Jump to content

lkruitwagen

New Members
  • Posts

    3
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

lkruitwagen's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. yeah well before i had it in a FOR loop but for some reason that didn't work. I've gone back and changed the FOR loop to a WHILE loop and it is working now. I think this is because in the FOR loop it was just trying to execute the whole loop, where as the WHILE loop requires it to continue and continue. I also made it print the increasing integer to the browser so the browser page is kept busy. It isn't fast, but time was never really my problem, I just needed it not to time out. I'm sending millions of data entries so I would expect it to take a while. I'm inputting the data one row at a time, if that's what you mean, in long Query statements. Thanks for all the help! Problem Solved!
  2. unfortunately the file size cannot be reduced. the users will be people other than me, so they just need to upload their file and go I'm trying to reprogram it so it doesn't use 2-d arrays. I've made some of the algorithms a lot simpler too. and I will write some functions in, those are just like procedures right? Thanks a lot!!!
  3. Hey, This is driving me nuts, I've written programming which reads from a file and then inputs that data into a SQL database. I use a two dimentional array to hold all my data. the script works perfectly with small test sections of the file (about 9000 lines), but when i execute it with the entire file (almost 200,000 lines), I get a time-out error. I increased the size and time restrictions, so now instead of a time-out I get an internal server error after about 15 minutes. any ideas? Is the 2-D array slowing it down perhaps?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.