I got some idea. add 2 column in voipuser table. max-session -> Integer inuse-session ->Integer And create trigger for insert,update in Voipcall table. If acctstoptime = 0 Inc inuse-session If acctstoptime > 0 Dec inuse-session For Authen modules if inuse >= max-session reply fail Please comment. Dome C. Quoting Vahram Igityan <vx@xxxxxxxxxxx>: > Hello dome, > > It's depend how you design db structure and optimize queries. > > > > Wednesday, June 2, 2004, 7:51:01 PM, you wrote: > > dtct> I'm worry about authen is slow when voipcall table is big. > > > > dtct> Quoting Vahram Igityan <vx@xxxxxxxxxxx>: > > >> Hello dome, > >> > >> IHMO, easyest way, is check whenever AccSessonStop value in radius db is > >> not filled > >> > >> Wednesday, June 2, 2004, 6:43:27 PM, you wrote: > >> > >> dtct> Oh. it's ia very power full example michal. Do you have some Idea > for > >> do that. > >> dtct> No i add on some feature. > >> dtct> - Rate group for check tariff rate pre group user. > >> dtct> - Payment table for refill > >> dtct> But for Simultaneous Connections I have no algorithm. i try to do > many > >> way but > >> dtct> not work. > >> dtct> Please guide some idea > >> > >> dtct> Dome C. > >> > >> > >> dtct> Quoting Michal Zygmuntowicz <m.zygmuntowicz@xxxxxxx>: > >> > >> >> No. It's a simple example only. > >> >> > >> >> On Wed, 2004-06-02 at 14:58, dome@xxxxxxxxx wrote: > >> >> > Dear all, > >> >> > > >> >> > Can billing in contrib support limit Simultaneous Connections ? > >> >> > > >> >> > Dome C. > >> >> > >> >> > >> >> > >> >> > >> >> ------------------------------------------------------- > >> >> This SF.Net email is sponsored by the new InstallShield X. > >> >> From Windows to Linux, servers to mobile, InstallShield X is the one > >> >> installation-authoring solution that does it all. Learn more and > >> >> evaluate today! http://www.installshield.com/Dev2Dev/0504 > >> >> > >> >> _______________________________________________________ > >> >> > >> >> List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx > >> >> Archive: > >> http://sourceforge.net/mailarchive/forum.php?forum_id=8549 > >> >> Homepage: http://www.gnugk.org/ > >> >> > >> > >> > >> > >> > >> dtct> > >> ---------------------------------------------------------------------- > >> > >> > >> dtct> ------------------------------------------------------- > >> dtct> This SF.Net email is sponsored by the new InstallShield X. > >> dtct> From Windows to Linux, servers to mobile, InstallShield X is the > one > >> dtct> installation-authoring solution that does it all. Learn more and > >> dtct> evaluate today! http://www.installshield.com/Dev2Dev/0504 > >> > >> dtct> _______________________________________________________ > >> > >> dtct> List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx > >> dtct> Archive: > >> dtct> http://sourceforge.net/mailarchive/forum.php?forum_id=8549 > >> dtct> Homepage: http://www.gnugk.org/ > >> > >> > >> > >> -- > >> Best regards, > >> Vahram mailto:vx@xxxxxxxxxxx > >> > >> > >> > >> ------------------------------------------------------- > >> This SF.Net email is sponsored by the new InstallShield X. > >> From Windows to Linux, servers to mobile, InstallShield X is the one > >> installation-authoring solution that does it all. Learn more and > >> evaluate today! http://www.installshield.com/Dev2Dev/0504 > >> > >> _______________________________________________________ > >> > >> List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx > >> Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 > >> Homepage: http://www.gnugk.org/ > >> > > > > > dtct> ---------------------------------------------------------------------- > > > dtct> ------------------------------------------------------- > dtct> This SF.Net email is sponsored by the new InstallShield X. > dtct> From Windows to Linux, servers to mobile, InstallShield X is the one > dtct> installation-authoring solution that does it all. Learn more and > dtct> evaluate today! http://www.installshield.com/Dev2Dev/0504 > > dtct> _______________________________________________________ > > dtct> List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx > dtct> Archive: > dtct> http://sourceforge.net/mailarchive/forum.php?forum_id=8549 > dtct> Homepage: http://www.gnugk.org/ > > > > -- > Best regards, > Vahram mailto:vx@xxxxxxxxxxx > > > > ------------------------------------------------------- > This SF.Net email is sponsored by the new InstallShield X. > From Windows to Linux, servers to mobile, InstallShield X is the one > installation-authoring solution that does it all. Learn more and > evaluate today! http://www.installshield.com/Dev2Dev/0504 > > _______________________________________________________ > > List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx > Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 > Homepage: http://www.gnugk.org/ > ---------------------------------------------------------------------- ------------------------------------------------------- This SF.Net email is sponsored by the new InstallShield X. >From Windows to Linux, servers to mobile, InstallShield X is the one installation-authoring solution that does it all. Learn more and evaluate today! http://www.installshield.com/Dev2Dev/0504 _______________________________________________________ List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 Homepage: http://www.gnugk.org/
