Bill Shupp wrote:
>
> on 7/12/01 11:48 PM, Green Onyx at [EMAIL PROTECTED] spake:
>
> > Does anyone know a way that when you hit Change Password on the mod_user
> > screen you can make it go back to the user listing instead of the main menu.
> > I've hit a few situations where I'm changing numerous passwords and once and
> > it would be nice to be able to hit change password and be right back in the
> > user listing where I was.
>
> You have to modify the source. Not sure what version you are running, but
> on 0.60pre4, around line 474 of user.c, change it to call show_users()
> instead of moduser(). Then recompile.
The new moduser code I have does that. You modify a user and
it takes you right back to the same place. Not back to any
other page. Once I'm back on the job with qmailadmin I can
review all the pages and have them keep you on the same page.
On a separate topic, I was looking over the sql queries in
vpopmail and qmailadmin for optimization. Most queries use
user/domain so the mysql index on user/domain works well.
All except the show users page. I was watching people use
qmailadmin and that is the page they look at most. So I
tested creating a new index on the table.
create index domain_idx on vpopmail ( pw_domain(10) );
Results:
vpopmail has 159,197 records
before the index, display user page takes 4.5 seconds to render
after the index, display user page takes 1.5 seconds.
I'd say we should probably include the new index in future
vpopmail versions for mysql.
Ken Jones
