Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    New Coder
    Join Date
    Aug 2008
    Posts
    51
    Thanks
    18
    Thanked 0 Times in 0 Posts

    PHP Photo Gall is it quicker to pull from database?

    I have alot of photos and videos on our family website. It works great for me with cabel, but I have family with satilite, dsl and dialup and they take forever to load. Would they load quicker if I pulled the photos from a database instead of a image/video file on my server? Just don't want to rewite it if it's not gonna matter.

  • #2
    Regular Coder ninnypants's Avatar
    Join Date
    Apr 2008
    Location
    Utah
    Posts
    504
    Thanks
    10
    Thanked 47 Times in 47 Posts
    It shouldn't be a big difference, but you may trying to pull out fewer files at a time which will help

  • #3
    Regular Coder
    Join Date
    May 2008
    Location
    Ohio
    Posts
    231
    Thanks
    3
    Thanked 21 Times in 21 Posts
    You might also try using GD or ImageMagick to size down the images before sending them. Decrease thumbnail sizes on the gallery if you can. Another good idea would be to enable image caching (if the gallery has an option for it).
    zok@zoklet:~$ whereis zok
    zok: http://zoklet.net | http://zoklet.net/otg | /derzok/at/gmail/dot/com

  • #4
    New Coder
    Join Date
    Aug 2008
    Posts
    51
    Thanks
    18
    Thanked 0 Times in 0 Posts
    Hmm, thats a bummer. Thanks for your help.

  • #5
    Super Moderator Inigoesdr's Avatar
    Join Date
    Mar 2007
    Location
    Florida, USA
    Posts
    3,647
    Thanks
    2
    Thanked 406 Times in 398 Posts
    Quote Originally Posted by samsfriend View Post
    Would they load quicker if I pulled the photos from a database instead of a image/video file on my server?
    No. In fact it will be slower. If you want to allow members of your family with slower internet connections to be able to view the content I would suggest you either do as previously suggested, and resize all of your images, or have a option they can select like "I have slow internets" and resize them on-the-fly. With the videos there's no easy way to do it, so you might want to tell them to avoid the videos altogether, or make smaller versions of the same videos and upload them separately.

  • #6
    New Coder
    Join Date
    Aug 2008
    Posts
    51
    Thanks
    18
    Thanked 0 Times in 0 Posts
    So I could do a quickload simple version of our site for those with slow internet? I am going to have to look that up on what's quick loading for those connections.


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •