folder balance solution?

[jasondavis]

I have aroudn 100,000 images uploaded from an upload form which saves the location to my mysql then uploads to the folder I set it to

example

images/13

will upload picture.jpg to /images/13/picture.jpg and in my db save the name as "13/picture.jpg"

The problem Is I have to manually change the number to in my upload scripts every so often to go to a new folder I'm looking for a way for it to do this automaticly, the reason is so there isnt to many files in each folder for performance

[cgraz]

if your pattern is always images/<number>/<picture>

why not just store <picture.jpg> (whatever the name of the picture is) in your table, then use the unique id from that row as the <number>

so for example, if you're uploading an image for ItemID 245, you pull the name of the picture from your table for that row (let's say myPicture.jpg), then store it and read it on the filesystem from

images/245/myPicture.jpg

Not sure if I understood you correctly, but hopefully this helps!

[jasondavis]

The problem with that is that the number would be a users number so right now, that would create like 50,000 image folders

[cgraz]

Ahh I didn't get that from your initial post.

What if you used PHP to decide what folder to put them in. For example, lets say you wanted to have only 1000 users using a particular folder.

Assuming their UserID is set to auto_increment,

ceil(userID/1000)

examples:
UID = 400 -> 1
uID = 1100 -> 2
uID = 4250 -> 5

This is a rough estimate as you will realistically have gaps in your userID, but it's a way to ensure you never have more than 1000 users sharing a particular folder.

[jasondavis]

Not sure I would wanna do it by member ID but maybe could user the userid from

my picture table like it has a row auto_id its largest number is now 34793 if it could determine a way to + the number for the folder ever 2,000 numbers higher would be my best way i think

[jasondavis]

ok here is my new idea, I will make sure I have around 2,000 images per folder by counting the rows in the DB, just wondering if there is a more elegant way to do this instead of 200 lines of code

<?php
$rownumber = 79757;
	switch ($rownumber) {
	    case $rownumber<=2000:
	    $folder = 1;
	    break;
	    case $rownumber<=4000:
	    $folder = 2;
	    break;
	    case $rownumber<=6000:
	    $folder = 3;
	    break;
	    case $rownumber<=8000:
	    $folder = 4;
	    break;
    	case $rownumber<=10000:
	    $folder = 5;
	    break;
	    case $rownumber<=12000:
	    $folder = 6;
	    break;
	    case $rownumber<=14000:
	    $folder = 7;
	    break;
	    case $rownumber<=16000:
	    $folder = 8;
	    break;
	    case $rownumber<=18000:
	    $folder = 9;
	    break;
	    case $rownumber<=20000:
	    $folder = 10;
	    break;
	    case $rownumber<=22000:
	    $folder = 11;
	    break;
	    case $rownumber<=24000:
	    $folder = 12;
	    break;
	    case $rownumber<=26000:
	    $folder = 13;
	    break;
	    case $rownumber<=28000:
	    $folder = 14;
	    break;
	    case $rownumber<=30000:
	    $folder = '15/1';
	    break;
	    case $rownumber<=32000:
	    $folder = '15/2';
	    break;
	    case $rownumber<=34000:
	    $folder = '15/3';
	    break;
	    case $rownumber<=36000:
	    $folder = '15/4';
	    break;
	    case $rownumber<=38000:
	    $folder = '15/5';
	    break;
	    case $rownumber<=40000:
	    $folder = '15/6';
	    break;
	    case $rownumber<=42000:
	    $folder = '15/7';
	    break;
	    case $rownumber<=44000:
	    $folder = '15/8';
	    break;
	    case $rownumber<=46000:
	    $folder = '15/9';
	    break;
	    case $rownumber<=48000:
	    $folder = '16/1';
	    break;
	    case $rownumber<=50000:
	    $folder = '16/2';
	    break;
	    case $rownumber<=52000:
	    $folder = '16/3';
	    break;
	    case $rownumber<=54000:
	    $folder = '16/4';
	    break;
	    case $rownumber<=56000:
	    $folder = '16/5';
	    break;
	    case $rownumber<=58000:
	    $folder = '16/6';
	    break;
	    case $rownumber<=60000:
	    $folder = '16/7';
	    break;
	    case $rownumber<=62000:
	    $folder = '16/8';
	    break;
	    case $rownumber<=64000:
	    $folder = '16/9';
	    break;
	    case $rownumber<=66000:
	    $folder = '17/1';
	    break;
	    case $rownumber<=68000:
	    $folder = '17/2';
	    break;
	    case $rownumber<=70000:
	    $folder = '17/3';
	    break;
	    case $rownumber<=72000:
	    $folder = '17/4';
	    break;
	    case $rownumber<=74000:
	    $folder = '17/5';
	    break;
	    case $rownumber<=76000:
	    $folder = '17/6';
	    break;
	    case $rownumber<=78000:
	    $folder = '17/7';
	    break;
	    case $rownumber<=80000:
	    $folder = '17/8';
	    break;
	    case $rownumber<=82000:
	    $folder = '17/9';
	    break;
	    case $rownumber<=84000:
	    $folder = '18/1';
	    break;
	    case $rownumber<=86000:
	    $folder = '18/2';
	    break;
	    case $rownumber<=88000:
	    $folder = '18/3';
	    break;
	    case $rownumber<=90000:
	    $folder = '18/4';
	    break;
	    case $rownumber<=92000:
	    $folder = '18/5';
	    break;
	    case $rownumber<=94000:
	    $folder = '18/6';
	    break;
	    case $rownumber<=96000:
	    $folder = '18/7';
	    break;
	    case $rownumber<=98000:
	    $folder = '18/8';
	    break;
	    case $rownumber<=100000:
	    $folder = '18/9';
	    break;
	    case $rownumber<=102000:
	    $folder = '19/1';
	    break;
	    case $rownumber<=104000:
	    $folder = '19/2';
	    break;
	    case $rownumber<=106000:
	    $folder = '19/3';
	    break;
	    case $rownumber<=108000:
	    $folder = '19/4';
	    break;
	    case $rownumber<=110000:
	    $folder = '19/5';
	    break;
	    case $rownumber<=112000:
	    $folder = '19/6';
	    break;
	    case $rownumber<=114000:
	    $folder = '19/7';
	    break;
	    case $rownumber<=116000:
	    $folder = '19/8';
	    break;
	    case $rownumber<=118000:
	    $folder = '19/9';
	    break;

    default:
    $folder = 1;
    break;
}
echo $folder;

?>

[Weedpacket]

jasondavis wrote:

just wondering if there is a more elegant way to do this instead of 200 lines of code

Sure there is; use a little arithmetic. Division and modulus operators. Something along the lines of [man]ceil[/man] or [man]round[/man] to round numbers to an integer when the division isn't exact.

Don't bother using different systems for different ranges unless you really really need to: otherwise it's just unnecessary complication.

$dir = 1+($rownumber%30000)/2000;
$subdir = 1+($rownumber-($rownumber%2000))/2000.

[Not real code]