Results 1 to 10 of 11

Thread: optimize the mysql table

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Sep 2007
    Posts
    906

    Default

    you can delete all entry from the table using following command.

    Code:
    DELETE FROM guest_info;
    Set guest limit to 0 to disable guest limit, so nothing will be written to this table.
    vShare Hosting, vShare Installation, Server Setup, Lighttpd streaming, vShare Templates
    [email protected]

  2. #2
    Join Date
    Jul 2010
    Posts
    19

    Default

    So let me first off say "thank you". I appreciate your help! :)

    Second... I do need a little more education when it comes with working with phpmyadmin. Is it possible for you to give me a step by step process of what to do with the command you gave me?
    Code:
    ---------
    DELETE FROM guest_info;
    ---------

    Where do I go and what do I do with this? :) I am a quick study. But, I truly don't know what to do or how to do it!

    Thanks
    David

  3. #3
    Join Date
    Jul 2010
    Posts
    19

    Default

    Quote Originally Posted by hostonnet View Post
    Set guest limit to 0 to disable guest limit, so nothing will be written to this table.

    So if I set this to 0 that means guests have to register to view videos?

  4. #4

    Default

    * 0 - When guest limit is set to 0, guests are allowed unlimited viewing.


    * 3600 - When guest limit is set to 3600, guests are are forwarded to signup page after visitor have watched videos for duration 3600 seconds, that is total of 1 hour video. Then he need to register on the site to watch more videos.


    * If you set value to 1, since most video's have duration higher than 1 second, guest users will get forwarded to signup page when he click to view a video.

  5. #5
    Join Date
    Jul 2010
    Posts
    19

    Default

    So I did what you said "DELETE FROM guest_info;" it worked wonders! My site performance is 100000% better!

    Thanks for your help on this one!

Tags for this Thread

Bookmarks

Posting Permissions

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