Gossamer Forum
Home : Products : Links 2.0 : Customization :

review.db too big

Quote Reply
review.db too big
i'm using the widgetz review mod, currently my database is getting too big over 10000 reviews, and the rewview page is loading very slow cuz this, is it possible to have links start another review.db like review2.db, but still average out the ratings from the 1st db?
or possible for it to average out the ratings for all IDs and make it into one review, forget bout the actually reviews and ip, date, i only cared bout maintaing the average rating!

Quote Reply
Re: review.db too big In reply to
10000 reviews?

How many links do you have?

Seriously consider Links SQL

Mods:http://wiredon.net/gt/download.shtml
Installations:http://wiredon.net/gt/
Quote Reply
Re: review.db too big In reply to
only around 200 links, thta's y i don't feel like i wanted spend extra for sql!
Quote Reply
Re: review.db too big In reply to
so paul do any othre way to help, i really can't upgrade to sql cuz many mods was istlled on links 2, it'll take a lot of money and time for other people to port these mods into sql version!

Quote Reply
Re: review.db too big In reply to
couldn't you just use a different type of review system? I'm not saying what you're using is bad, just an idea I had.


good luck

**************************************
on the pages in between ...
Quote Reply
Re: review.db too big In reply to
I wish I knew more about SQL and maybe I would then be able to help you. Im sure there is a pretty easy way to turn the flat file database to a mySQL version. I will look around and if I find it I will let you know.
Good Luck,
Paul

Hot Web Hosting
Low cost web hosting:
http://www.thehotweb.net/webhosting
Quote Reply
Re: review.db too big In reply to
thx anyway hacker!

Quote Reply
Re: review.db too big In reply to
ummm ... check out www.hotscripts.com they have a large asortment of scripts available. Recently, I've had the php bug, I remember seeing different open-source solutions for providing a comment sections. Also, getting php to run inside of GT scripts isn't difficult eventhough some claim it won't work. I got phpAdsNew running without a hickup.

I know that widgets mod is great and intergrates well with Links but if you're getting performance hits maybe you can just use an outside script with a little creativity to add it in.

good luck

**************************************
on the pages in between ...
Quote Reply
Re: review.db too big In reply to
Anyone got a URL for that user review script? The only link I could see in the resource section just leads to some portal. I've been so far unsuccessfully looking through here for that reviews script, it sounds perfect for what I want.

Quote Reply
Re: review.db too big In reply to
Review.cgi and now ReviewIt as well are not available anymore. Check out this forum and the Resource Center for Glenn's Comments scripts.

Thomas
http://links.japanref.com