Gossamer Forum
Home : Gossamer Threads Inc. : Discussion :

Re: New SQL version

Quote Reply
Re: New SQL version In reply to
in v1.1 i made a build changed version of nph-build.. it used Mod_Date and a Last_Built field to determine whether or not it had changed or not.. and basically the select statement weeded out only the ones needed..

i did the same for categories.. but i had to do the processing in PERL..

the only thing i found not very good about it was if you added categories or something or changed the design or have a few mods that change data like review numbers or ratings.. then the page will be old.. so i still had to use nph-build.cgi every once in awhile..

there was a big difference though..
goin to nph-build.cgi would take somewhere around 50 minutes..

the first of nph-changed.cgi didn't build any detailed or category pages.. because they all were already built

so i edited a few links and then built again and only those links.. the category and subcategories were built..

took 5 seconds

so i waited about 5 days.. let things get modified and changed like usual and didn't build.. then built with nph-changed..

only 24 detailed pages built.. and a total of 63 category and subcategories built..

once again in under a minute..

after about a month of that.. i noticed the detailed pages of links not modified had static rating information..

the only thing i could think of to fix that problem is adding another field to the links database and updating it with the date every single time the link is changed at all.. mod_date is when it is updated by the user.. so basically.. in nph-build.cgi when the ratings are added to the links database.. it would need to update the new field..



Jerry Su
Subject Author Views Date
Thread New SQL version Robert 4005 Jul 8, 2000, 11:02 AM
Thread Re: New SQL version
pugdog 3901 Jul 8, 2000, 12:09 PM
Thread Re: New SQL version
jsu 3864 Jul 8, 2000, 6:06 PM
Post Re: New SQL version
pugdog 3853 Jul 9, 2000, 11:19 AM