Testing program record max.

[techrat]

I've written a script that I need to test for overload breakage. The script does several things:

Parses a CSV file (101 fields, over 1200 records) into an array
Grabs the first line of the array to create a temp table & columns
Populates the temp table with the rest of the array data
Selects the 'real' data from the temp table into the real table
Displays the counts for the scrubbed data

Another script I'm writting will deal with manipulating the real database. What I would like to find out is if someone knows a good way for me to test this thing to see what is the MAX number of records it will process before memory or timer overload?

Before someone asks:
The client refuses to accept a web based interface for inputting the data directly into a database. The script wont be running on my server, so I wont be able to change the timer or memory settings. I just need a way to find out how many records this thing will handle before crapping out. Anybody know how?

PS. I need a useful answer, not conjecture.

Techrat
🙂

[wfig]

set a loop

something like

$loopmax = 1000;
$current = 0;

while ($lookmax > $current){
#...your code....#
echo $current;
echo "<br>";
$current++;
}

if you want you can set $loopmax to a bzillian, the code will keep on executing and continue on displaying the $current and as soon as you see a notice of failure on the browser, look at the last "$current" value.

Hope it helps

🙂

[bbaassiri]

Im sure you need to get ur script not to time out

set_time_limit(0);

im not sure you can pre-determine the system settings to handle you data load, that kind of stuff will need to happen at runtime

now is the script of yours in php?