InvestorsHub Logo
Followers 211
Posts 7903
Boards Moderated 15
Alias Born 05/24/2001

Re: None

Thursday, 05/16/2002 11:31:21 PM

Thursday, May 16, 2002 11:31:21 PM

Post# of 302
Major change:

Well, hopefully it'll seem a relatively insignificant change on the interface side of things, but it was major behind the scenes.

I just completed the following changes to the MailBox page:

1. It's all CSS'd now, which means it'll use the Message Box Color (settable on the My Interface page under the Tools menu) for odd-numbered rows.

2. Kept messages now have a link to UnKeep them from the MailBox page.

3. Alignment issues addressed.

4. You can now specify on the My Settings screen how many of each type of message to display on your MailBox page. The new field is called "Messages Per Category in MailBox". Pick a number from the dropdown and that's the maximum that will display for each of the 3 categories in your MailBox. Smaller numbers make the page load faster and bigger numbers make more messages available.

All in all the page should load a lot faster now anyway. It went from 308 lines of code down to 128, and the data being sent over the wires dropped by 1/3rd, mostly because of the CSS conversion, and all the SQL statements being replaced by one stored-procedure call.

Instead of 3 main on-the-fly queries, each of which called another subquery once for each message, it is all being fed now by one stored procedure. That's the part that should result in the biggest speed increase.

An additional minor change is that I widened the table on the My Settings screen so it'd look better.

As always, drop me a line if you see any weirdness.

Join the InvestorsHub Community

Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.