Frans
|
Posted: 09/03/2003, 2:11 AM |
|
Hello,
I'm looking for a proper MySql Solution to do the following.
Multiple tables with joins. If i build a query with the grid builder
all seems nice, but when i open the generated page i get a blank page.
Is there a MySql 3.23.X solution to speed up the queries or create a temp
table which hold the queries or something else. I noticed that if you
use more than 4 or 5 tables with about 2000+ records the generated page will
not come up.
I edited the php.ini file for better performance but had no success.
Thanks,
Frans
|
|
|
RonB
|
Posted: 09/03/2003, 5:23 AM |
|
In addition to my reply through email:
try and use the querybuilder to build the query and then switch to sql in querybuilder. The query qill ten be generated and try if the grid will display. I do this with comples queries to our Oracle database (10.000 records and more) and the page always generates.
Ron
|
|
|
|