[freeside-users] freeside 3.1 and mysql database

[Jason Hall]

In basic, go back to psql. We ran into the same issue when testing. The
problem is in the way the mysql parser counts joins. Everything referenced
in CASES and anywhere else each becomes another join. When doing even a bit
of logic it ramps up really fast.


On Thu, Nov 21, 2013 at 5:46 AM, Vladimir Grujic <hyperbabac at gmail.com>wrote:

> Hi,
> I've installed a freeside on a mysql (not postgresql) server and got into
> trouble when trying to access biling events creation page :
>
> Too many tables; MySQL can only use 61 tables in a join at
> /var/www/freeside/search/elements/search.html line 436
>
> Looks like EAV model is used in the design of the system. This does not
> scale well ... Is there any option (or code change) to avoid this type of
> behavior (in a sense of using temporary result tables ... ) or i need to go
> back to psql?
>
>
> Thanks,
> Vladimir
>
>
> _______________________________________________
> freeside-users mailing list
> freeside-users at freeside.biz
> http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users
>
>


-- 
Jayce^

Preparing Deseret - UtahPreppers
ΜΟΛΩΝ ΛΑΒΕ
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://freeside.biz/pipermail/freeside-users/attachments/20131123/17085a8e/attachment.html>