Log in

No account? Create an account
LiveJournal Development [entries|archive|friends|userinfo]
LiveJournal Development

[ userinfo | livejournal userinfo ]
[ archive | journal archive ]

November 14th, 2001

(no subject) [Nov. 14th, 2001|03:51 am]
LiveJournal Development


[music |hooverphonic - pink fluffy dinosaurs]

When setting up a LJ server, is there any way to avoid having to manually enter each user into the DNS system of the server and still being able to get [username].my-lj-server.com? Assuming not, I have to start meddling with BIND, correct?

link10 comments|post comment

Full Text Searches [Nov. 14th, 2001|09:36 am]
LiveJournal Development


I've been playing around with some full text search options here on a database I setup. I've found it to be quite speedy if you're searching against an indexed field.

SELECT entry FROM book WHERE entry LIKE '%foot%' AND rand = 5001;

Doing a search like that where rand is the indexed field, against 25k records returns 33 entries in 1.5 seconds. Now most LiveJournal users do not have 25k records so it would be faster than that. Even Brad only has 6396 entries. Looking at the schema of the DB here, it looks like LJ should be just about the same as my test. Plus LJ has much bigger hardware than what I used (Dual P2-450, Raid5).

Is there a reason not too allow full-text searching against a single users journal or even their comments? I would think if it was set it up to only query off some slave DB server it wouldn't make much of a performance difference. Maybe make it a paid user only service.

It would be really handy to be able to reference all past entries where I used the word 'jigga' if my current entry was about jiggas.
link13 comments|post comment

[ viewing | November 14th, 2001 ]
[ go | Previous Day|Next Day ]