Tabulas User Directory has been updated (after logging a few hours at the local PC cafe).

Notable changes:
- Page now "remembers" all settings you used to search with
- Nasty state bug (where it says everyone is from a certain state) has been fixed
- The last updated is stored statically now and you can use the "sort by last updated' parameter to find people
- You can input a keyword phrase (3 char minimum) that will limit the search to a specific phrase. This is using the simple '%PHRASE%' wildcard in mySQL. The username field is indexed, so this doesn't affect performance too badly.
- You can jump directly to a page.

Things to fix (still):
- Pagination is still a total mess. I'm going to rewrite the whole pagination system from scratch.
- "Network" function still does not work ... I've taken the link off and will implement it once it's done.

Besides that, tell me what you think... 8)

I've had to de-featurize Tabulas by removing the search feature. The search feature required a full-text index on the entries, which ended up being 250 megs+ on just the index. And the feature didn't scale worth a crap (boo). So I decided to scrap it for now. I need to sit down and write a proper search implementation rather than just using the FULL-TEXT and MATCH features in mySQL ... they just don't work.

So the database is breathing again at about 800 megs (it actually was more than a gig with the fulltext index).

I worry because I heard mySQL tends to get really bad ~1GB worth of data... DAMN I NEED TO BUY SOME NEW SERVERS.

Edit: The user directory (minus the 'network' feature) is now *done*. Please, for those of you with access, test it out and make sure it ALL works properly. You will be doing me a big favor 8) I want to post this to the main Tabulas journal sometime within the next 24 hours ... and then get started on the community feature.

Post bugs as comments below...
Posted by roy on July 24, 2004 at 09:28 PM in Web Development, Tabulas | 23 Comments

Related Entries

RoyKim (guest)

Comment posted on July 27th, 2004 at 08:35 AM
What a coincidence.

RoyKim (guest)

Comment posted on July 26th, 2004 at 08:56 AM
It\'s not perving man. It\'s like appreciating what God has created, or something.
Comment posted on July 26th, 2004 at 10:57 PM
er, quit!
Comment posted on July 26th, 2004 at 10:57 PM
quick using my name !!!

benstar (guest)

Comment posted on July 26th, 2004 at 12:03 AM
wtf!? is it even legal to perve on other ppls pics kyle ?

(if u find any hot asians, talk to me :P).

On a totally differnt note, roy needs to check out neopages..

MacDaddyTatsu (guest)

Comment posted on July 25th, 2004 at 05:20 PM
Wowly shit, you have really been igniting the midnight petroleum, havnt you Royo! Nice stuff. Once I do some laundry, Ill let you know what I find.

RoyKim (guest)

Comment posted on July 25th, 2004 at 01:33 PM
Shannon, are you spoken for?

Want to comment with Tabulas?. Please login.

sal (guest)

Comment posted on July 25th, 2004 at 11:04 AM
when changing any options while searching, it always returns

Warning: implode(): Bad arguments. in /home/mytabul/public_html/users/functions/header.php on line 199

sal (guest)

Comment posted on July 25th, 2004 at 11:15 AM
i replied too early cos i think i know what the prob is. prob was with the browser and how it submits forms wih image submit buttons. doesnt work with moz1.6/mac, does work with safari 1.2.

theres a little overflow with form elements, though nothing major
<a href="http://sal.neoburn.net/spare/stuff/tab_userdir_saf1.2.gif">http://sal.neoburn.net/spare/stuff/tab_userdir_saf1.2.gif</a>
Comment posted on July 26th, 2004 at 06:09 AM
I think I fixed the implode() error. let me know.
Comment posted on July 26th, 2004 at 11:07 PM
Ok, *should* be fixed; the implode() was just a bad error; it didn\'t affect any outputting.

kyle (guest)

Comment posted on July 25th, 2004 at 08:47 AM
Holy shit shannon. My god what a body. Are you sure you\'re not a model?
Comment posted on July 25th, 2004 at 12:28 PM
models scare me, they\'re so tall.

kyle (guest)

Comment posted on July 25th, 2004 at 06:01 AM
Roy Im working on the girls of tabulas site... you know theyre coutnless Live Journal stalkers I just want to get in on tabulas before it gets big. I\'ve found some real hunnies here, quite worthy of my attention.
Comment posted on July 25th, 2004 at 07:05 AM
lmao
Comment posted on July 25th, 2004 at 05:47 AM
A paid account also grants you access there 8)

sal (guest)

Comment posted on July 25th, 2004 at 04:57 AM
on the user directory, you need a radio button for \'Sexy chicks wih pics in their gallery\' for kyle. i\'m sure you could put it down as another feature for paid accounts :)
Comment posted on July 25th, 2004 at 05:18 AM
Haha. Perhaps...
Comment posted on July 24th, 2004 at 10:15 PM
perhaps a search on the last update field as well roy? thats all i can think of right now. i dig the color coding of users based on gender :)
Comment posted on July 25th, 2004 at 12:03 AM
Search on the last update? What do you mean?
Comment posted on July 25th, 2004 at 09:50 AM
search based on how active the user is. the last column view ^^ sorry for the bad wording.
Comment posted on July 25th, 2004 at 10:11 AM
o_0 im blind, it\'s already there. question though, does the last updated field update based on journal entries alone or gallery updates as well?
Comment posted on July 24th, 2004 at 09:33 PM
Yeah, it was down with function.mysql_connect again a few minutes ago.

Damn, I need to find some American cash. Or get a credit card.