<HTML><HEAD></HEAD>
<BODY dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: 12pt">
<DIV><SPAN
style="mso-fareast-language: en-za; mso-no-proof: yes">Hello,</SPAN></DIV>
<DIV><SPAN
style="mso-fareast-language: en-za; mso-no-proof: yes"></SPAN> </DIV>
<DIV><SPAN style="mso-fareast-language: en-za; mso-no-proof: yes"><STRONG><U>HOW
TO Speed up Freeside Billing (freeside-daily)</U></STRONG></SPAN></DIV>
<DIV><SPAN
style="mso-fareast-language: en-za; mso-no-proof: yes"></SPAN> </DIV>
<DIV><SPAN style="mso-fareast-language: en-za; mso-no-proof: yes">I have the
following installed:</SPAN></DIV>
<DIV><SPAN style="mso-fareast-language: en-za; mso-no-proof: yes">freeside
version 1.7.3.</SPAN></DIV>
<DIV><SPAN style="mso-fareast-language: en-za; mso-no-proof: yes">Debian 5.0
Lenny</SPAN></DIV>
<DIV><SPAN
style="mso-fareast-language: en-za; mso-no-proof: yes">HTML::Mason</SPAN></DIV>
<DIV><SPAN style="mso-fareast-language: en-za; mso-no-proof: yes">perl v5.
10.0</SPAN></DIV>
<DIV><SPAN style="mso-fareast-language: en-za; mso-no-proof: yes">PostgreSQL
8.3.6</SPAN></DIV>
<DIV><SPAN
style="mso-fareast-language: en-za; mso-no-proof: yes">DBI</SPAN></DIV>
<DIV><SPAN
style="mso-fareast-language: en-za; mso-no-proof: yes">DBD::Pg</SPAN></DIV>
<DIV><SPAN
style="mso-fareast-language: en-za; mso-no-proof: yes"></SPAN> </DIV>
<DIV><SPAN style="mso-fareast-language: en-za; mso-no-proof: yes">My question
is: is there anything that can be done to speed up the processing of the Billing
(Invoice generation for all customers) in Freeside? I have set up a cron job for
the default freeside-daily script that runs the Billing, and it takes about 90
seconds to process a single Customer !?!. Are there any known issues about
processing speed?.</SPAN></DIV>
<DIV><SPAN
style="mso-fareast-language: en-za; mso-no-proof: yes"></SPAN> </DIV>
<DIV><SPAN style="mso-fareast-language: en-za; mso-no-proof: yes">It is possible
I might have set up something wrongly ...looking forward to some
help/ideas...</SPAN></DIV>
<DIV><SPAN
style="mso-fareast-language: en-za; mso-no-proof: yes"></SPAN> </DIV>
<DIV><SPAN style="mso-fareast-language: en-za; mso-no-proof: yes">Kind
Regards,</SPAN></DIV>
<DIV><SPAN
style="mso-fareast-language: en-za; mso-no-proof: yes">Kajani</SPAN></DIV>
<DIV><SPAN
style="mso-fareast-language: en-za; mso-no-proof: yes"></SPAN> </DIV></DIV></DIV></BODY></HTML>