-
MorganL
-
-
Offline
-
Platinum Member
-
- Posts: 438
- Thank you received: 53
-
Karma: 15
-
|
I have unticked 'include dataset' and still cant download it, just sits and spins
Thanks
Morgan
|
Morgan Leecy MCSE
Novell / Linux
PHP. MYSQL, Apache, node.js
Coldfusion, JQuery, HTML5
Joomla
|
-
MorganL
-
-
Offline
-
Platinum Member
-
- Posts: 438
- Thank you received: 53
-
Karma: 15
-
|
Even though i was not including the dataset, once i flushed the datasets, i was able to download it
However if I try to add just one more view, I sit and spin again, but working for now
|
Morgan Leecy MCSE
Novell / Linux
PHP. MYSQL, Apache, node.js
Coldfusion, JQuery, HTML5
Joomla
|
-
admin
-
-
Offline
-
Administrator
-
-
Chef
- Posts: 3711
- Thank you received: 987
-
Karma: 140
-
|
This is because your project is too big.
|
Coding is now a piece of cake
|
-
MorganL
-
-
Offline
-
Platinum Member
-
- Posts: 438
- Thank you received: 53
-
Karma: 15
-
|
Its a big project for a big site
I will try to streamline it
|
Morgan Leecy MCSE
Novell / Linux
PHP. MYSQL, Apache, node.js
Coldfusion, JQuery, HTML5
Joomla
|
-
admin
-
-
Offline
-
Administrator
-
-
Chef
- Posts: 3711
- Thank you received: 987
-
Karma: 140
-
|
You have a table which is really huge.
It is a memory overflow, so the table size could be the reason.
I saw projects with more tables, but never a table with so much fields.
I am gonna check the load of the server, and I can maybe dedicate a bit more RAM memory, but thats only putting the limit a bit further.
|
Coding is now a piece of cake
|
-
MorganL
-
-
Offline
-
Platinum Member
-
- Posts: 438
- Thank you received: 53
-
Karma: 15
-
|
Yes, one of the tables is full of meta data for an object
I have managed to download it now and will see what I can do to shrink it or even break it up if possible
Maybe you need an extra premium service payment for greedy buggers like me
|
Morgan Leecy MCSE
Novell / Linux
PHP. MYSQL, Apache, node.js
Coldfusion, JQuery, HTML5
Joomla
|
-
Romkabouter
-
-
Offline
-
Elite Member
-
- Posts: 310
- Thank you received: 131
-
Karma: 48
-
|
Might be smaller if you use a JSON field
|
|
-
admin
-
-
Offline
-
Administrator
-
-
Chef
- Posts: 3711
- Thank you received: 987
-
Karma: 140
-
|
Correct.
Anyone knows better how to use JSON field inside a SQL query, of research ?
JSON is a SQL type. So I guess the contained values can be searchable, like a tree of values, any help on this ?
Because Cook do not handle JSON as a SQL JSON field. If you use JSON with Cook, it will store it into a text field.
I'd like to improve that but I never dig in really. That's the opportunity to improve something.
Anyone who used SQL JSON field with SQL queries ?
|
Coding is now a piece of cake
|
-
admin
-
-
Offline
-
Administrator
-
-
Chef
- Posts: 3711
- Thank you received: 987
-
Karma: 140
-
|
By the way (and Morgan knows already), I have increased the RAM memory limit which helps for our problem of downloading.
|
Coding is now a piece of cake
|
-
Romkabouter
-
-
Offline
-
Elite Member
-
- Posts: 310
- Thank you received: 131
-
Karma: 48
-
|
|
|
|