2004/12/08
IRC [04:13] *** brunom parted the chat.
IRC [06:27] *** frankie joined the chat.
IRC [06:43] *** frankie parted the chat.
IRC [11:43] *** rubick-away parted the chat.
IRC [12:21] <jhavard> lucky
IRC [12:21] <jhavard> wrong window
IRC [12:34] <Dossy> yes! the mozilla guys released thunderbird, and they're working on Mozilla Calendar (Sunbird)
IRC [12:45] *** rubick-away joined the chat.
IRC [12:49] <jhavard> okay, so just how does this nsjk2 thing work?
IRC [12:58] <Dossy> heh
IRC [12:58] <Dossy> you build it. you install/configure it. you serve .jsp with it.
IRC [13:03] <Dossy> do you have any particular questions?
IRC [13:18] <jhavard> well, I just read http://www.aolserver.com/docs/nsjk2.pdf and it clarified everything.
IRC [13:51] <Dossy> yay.
IRC [14:33] *** iharding joined the chat.
IRC [15:16] *** webwolf_27 joined the chat.
IRC [15:17] <webwolf_27> hi people
IRC [15:20] *** webwolf_27 parted the chat.
IRC [15:29] *** iharding parted the chat.
IRC [15:47] *** natester_food joined the chat.
IRC [15:49] <natester_food> it would be good to create a bunch of static html pages that represent the data returned by dynamic .adp pages at one time. What is a good way to do that?
IRC [15:51] <Dossy> set fd [open /path/to/html w]; puts $fd $data; close $fd
IRC [15:51] <Dossy> ?
IRC [15:51] <natester_food> hitting the database has the effect of making the gui look slower
IRC [15:52] <natester_food> so I would like to hit the database in the background and give the user static html to view
IRC [15:52] <natester_food> instead of letting him or her do live queries
IRC [15:52] <natester_food> capiche?
IRC [15:59] <natester_food> I don't want users to visit a page that queries the database, instead they visit static html generated by the page that queries the database
IRC [16:01] *** bartt joined the chat.
IRC [16:03] *** bartt parted the chat.
IRC [16:08] <jhavard> natester: or for something even faster, take a look at nscache.
IRC [16:08] <jhavard> stores all that goodness in ram.
IRC [16:09] <jhavard> Went from 63 hits per second to 2400 hits per second.
IRC [16:09] <natester> ok, and when the query returns distinct data?
IRC [16:09] <natester> so the hits per second went up?
IRC [16:09] <jhavard> yep.
IRC [16:09] <natester> is that good?
IRC [16:09] <natester> hits of what?
IRC [16:10] <jhavard> hits to the web site.
IRC [16:10] <natester> oooh
IRC [16:10] <jhavard> number of requests it could service in a period of time.
IRC [16:10] <natester> what if the query page returns basically the same data with a few differences?
IRC [16:10] <natester> does it still use nscahce?
IRC [16:10] <natester> cache
IRC [16:10] <natester> cache
IRC [16:10] <natester> cache
IRC [16:11] <jhavard> What I did was write a proc that is used to do database queries.
IRC [16:11] <jhavard> It checks to see if the query is cached, using the query itself as the key.
IRC [16:11] <jhavard> If so, return the result set from cache
IRC [16:12] <jhavard> otherwise, stuff the results in the cache and then return the results.
IRC [16:12] <jhavard> since nscache handles cache expiration, it's really that simple.
IRC [16:12] <natester> hmm ok now to decide nscache or static html
IRC [16:13] <natester> I could have a cron job running the common queries in the background just to keep nscache up to date
IRC [16:13] <jhavard> well, you could go a step further and cache the final pages in the cache.
IRC [16:16] <natester> final pages?
IRC [16:16] <jhavard> well, I was typing that at the same time you said your thing about the cron job, which was pretty much the same thing.
IRC [16:17] <natester> is the aolserver wiki a good place to read about nscache?
IRC [16:17] <jhavard> although you should be aware of ns_schedule_proc
IRC [16:18] <jhavard> err, for running a job that updates the cached pages.
IRC [16:18] <jhavard> and the wiki is good for everything.
IRC [16:19] <jhavard> http://www.panoptic.com/wiki/aolserver/222
IRC [16:20] <natester> is it good for pina coladas?
IRC [16:20] <natester> and a trip to hawaii?
IRC [16:20] <jhavard> Maybe.
IRC [16:20] <jhavard> I wouldn't doubt it.
IRC [16:21] <natester> yeah
IRC [16:21] <jhavard> It saved me money on my car insurance.
IRC [16:21] <natester> :)
IRC [16:21] <natester> prevents hairloss
IRC [16:22] <jhavard> It will indeed save you from pulling your hair out.
IRC [16:22] <natester> um The module is only compatible with nsd8x, not nsd76 ?! does that need to be updated?
IRC [16:22] <Dossy> probably not.
IRC [16:22] <Dossy> if you're still running nsd76, stop.
IRC [16:23] <natester> I just meant to include nsd
IRC [16:24] <natester> keep your hair in its pores
IRC [16:24] <natester> nsd == nsd8x?
IRC [16:27] <natester> I updated it "The module is only compatible with nsd8x, nsd, and not nsd76."
IRC [16:27] * natester ducks
IRC [16:30] <Dossy> "8x" just refers to Tcl 8.x
IRC [16:31] <Dossy> To be clear, it should probably say "AOLserver 3.x using nsd8x, or AOLserver 4.x"
IRC [16:32] *** frankie joined the chat.
IRC [16:35] <Dossy> hi, frankie.
IRC [16:38] <natester> jhavard: nscache is not in my default install. Is it a seperate package like nsopenssl or nspostgres?
IRC [16:39] <Dossy> yes
IRC [16:39] <Dossy> i'm (someday) going to integrate the functionality of nscache back into the aolserver core
IRC [16:39] <Dossy> although I really dislike the tcl API naming
IRC [16:46] <frankie> Dossy: hi
IRC [16:57] *** iharding joined the chat.
IRC [16:59] <jhavard> Dossy: yeah, I hate "big" commands that should be several small commands
IRC [17:06] <Dossy> hi iharding
IRC [17:06] <Dossy> going to stick around this time?
IRC [17:11] <iharding> Hello
IRC [17:12] <iharding> It's hard to tell... Connectivity is not good.
IRC [17:17] *** frankie parted the chat.
IRC [17:37] *** iharding parted the chat.
IRC [18:08] *** bartt joined the chat.
IRC [19:06] *** natester parted the chat.
IRC [19:34] *** brunom joined the chat.
IRC [20:59] *** rubick parted the chat.
IRC [21:48] *** bartt parted the chat.
IRC [22:20] *** bartt joined the chat.