I was adding new fields in the links table and it was pretty need to have their variables available to you right there without any manual changes. But than realized that I need a brand new table other way I won't be able to do what I actually need. I know that just by adding new table I won't be able to pull anything out of it - need to write some code first, but which file(s) should be used? Basically I just neet to pull out data from the table as is - nothing fancy, but I want to be able to use variables in the templates. Would be need to have it like an additional module that could be turned on/off in switches and you good to go. What's the easiest way on adding tables and working within WSNLinks theme?
A new table would be an entirely new type of data and purpose not related to WSN Links and therefore you basically have to rewrite the script to match your purpose.
I desided to bump this topic up again since I think it might be related to the purpose of the directory at least from what I thik..
Anyways, here is what I was thinking - I would like to add fields like company name, address, contact information and everything that goes with it - basically extend merber's listing to make it more search effective. I though by adding more fields to the links table it will slow down things,and adding another table would make it easier. I don't khow this fur sure, just a guess. So, this is related to the directory purpose I think... what do you say?
I don't think adding a bunch of custom fields will slow it down. I have a bunch of WSN Links sites, none of which is used for links. Each has a LOT of custom fields.
Works great. WSN Links is the best Article Management, News CMS, BLOG, Personals, and classifieds script there is. There are so many features that it works for just about anything you can think of, and everything is customizable to fit.
Add away without touching the PHP, you'll be fine.
Tables are much slower to query than fields. Guides to mysql optimization commonly mention that it's good practice to try to merge tables where possible.
I tried a cross-table query not long ago and found it hopelessly slow on a large database, so that it basically killed the site... I had to add the field I needed back into the original table so that the selection would only come out of one talbe.
If your apache is running mod_gzip, then you don't need to do anything -- leave the WSN gzip setting off, as it would simply interfere with apache's version
Paul wrote: If your apache is running mod_gzip, then you don't need to do anything -- leave the WSN gzip setting off, as it would simply interfere with apache's version
That's the problem - my apache is not running mod_gzip.
well, I'm getting a little confused, but here is what I have in my php.ini:
------------------------------------- Directive Local Value Master Value output_buffering no value no value output_handler ob_gzhandler no value ------------------------------------- ZLib Support enabled Compiled Version 1.1.4 Linked Version 1.1.4 ------------------------------------- Directive Local Value Master Value zlib.output_compression Off Off zlib.output_compression_level -1 -1 zlib.output_handler no value no value -------------------------------------
My host told me to add the following line to the .htaccess CODE: php_value output_handler ob_gzhandler
it actually helped - I didn't have the blank page anymore, but some options just stoped working (as I mentioned before).
Comments on adding new tables
Forum Regular
Usergroup: Customer
Joined: Oct 30, 2003
Total Topics: 54
Total Comments: 197
I was adding new fields in the links table and it was pretty need to have their variables available to you right there without any manual changes. But than realized that I need a brand new table other way I won't be able to do what I actually need. I know that just by adding new table I won't be able to pull anything out of it - need to write some code first, but which file(s) should be used? Basically I just neet to pull out data from the table as is - nothing fancy, but I want to be able to use variables in the templates. Would be need to have it like an additional module that could be turned on/off in switches and you good to go. What's the easiest way on adding tables and working within WSNLinks theme?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
A new table would be an entirely new type of data and purpose not related to WSN Links and therefore you basically have to rewrite the script to match your purpose.
Forum Regular
Usergroup: Customer
Joined: Oct 30, 2003
Total Topics: 54
Total Comments: 197
I desided to bump this topic up again since I think it might be related to the purpose of the directory at least from what I thik..
Anyways, here is what I was thinking - I would like to add fields like company name, address, contact information and everything that goes with it - basically extend merber's listing to make it more search effective. I though by adding more fields to the links table it will slow down things,and adding another table would make it easier. I don't khow this fur sure, just a guess. So, this is related to the directory purpose I think... what do you say?
Thank you.
Forum Regular
Usergroup: Customer
Joined: Feb 19, 2004
Location: Michigan
Total Topics: 57
Total Comments: 185
I don't think adding a bunch of custom fields will slow it down. I have a bunch of WSN Links sites, none of which is used for links. Each has a LOT of custom fields.
Works great. WSN Links is the best Article Management, News CMS, BLOG, Personals, and classifieds script there is. There are so many features that it works for just about anything you can think of, and everything is customizable to fit.
Add away without touching the PHP, you'll be fine.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Tables are much slower to query than fields. Guides to mysql optimization commonly mention that it's good practice to try to merge tables where possible.
I tried a cross-table query not long ago and found it hopelessly slow on a large database, so that it basically killed the site... I had to add the field I needed back into the original table so that the selection would only come out of one talbe.
Forum Regular
Usergroup: Customer
Joined: Oct 30, 2003
Total Topics: 54
Total Comments: 197
Okay. Thanks for making it clear to me
I still want to find out how to get that mod_gzip working properly to speed it up.
Thanks a lot!
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
If your apache is running mod_gzip, then you don't need to do anything -- leave the WSN gzip setting off, as it would simply interfere with apache's version
Forum Regular
Usergroup: Customer
Joined: Oct 30, 2003
Total Topics: 54
Total Comments: 197
If your apache is running mod_gzip, then you don't need to do anything -- leave the WSN gzip setting off, as it would simply interfere with apache's version
That's the problem - my apache is not running mod_gzip.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Well, did you check if you have the settings mentioned in the manual entry as causing it to fail?
Forum Regular
Usergroup: Customer
Joined: Oct 30, 2003
Total Topics: 54
Total Comments: 197
well, I'm getting a little confused, but here is what I have in my php.ini:
-------------------------------------
Directive Local Value Master Value
output_buffering no value no value
output_handler ob_gzhandler no value
-------------------------------------
ZLib Support enabled
Compiled Version 1.1.4
Linked Version 1.1.4
-------------------------------------
Directive Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no value
-------------------------------------
My host told me to add the following line to the .htaccess CODE:
php_value output_handler ob_gzhandler
it actually helped - I didn't have the blank page anymore, but some options just stoped working (as I mentioned before).
Forum Regular
Usergroup: Customer
Joined: Oct 30, 2003
Total Topics: 54
Total Comments: 197
hmm.. I just checked my site with
http://www.desilva.biz/gzip-test.php and it says it is compressed...
Forum Regular
Usergroup: Customer
Joined: Oct 30, 2003
Total Topics: 54
Total Comments: 197
Okay, I took that line out from .htaccess and the tool said that my pages are not gziped - I put it back it and it said I save 79%.
I believe that resolves the problem. I need less havier graphics.
Thank you Paul!