Maximum size of SQLQuery with revDataFromQuery ?

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Maximum size of SQLQuery with revDataFromQuery ?

** Clarence P Martin ** via use-livecode
Hello
Is there a size limit for the SQLQuery parameter when using
revDataFromQuery ?
I might end up with mySQL queries of at least 75 Kb...
I know the best way to know is to try, but any experience would be
apreciated...

FYI some of there queries have been tested in PHPmyAdmin and run in 0.0054
sec;
my concern was rather the buffer size between LC engine and mySQL...

Thanks in advance.
jbv


_______________________________________________
use-livecode mailing list
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Maximum size of SQLQuery with revDataFromQuery ?

** Clarence P Martin ** via use-livecode
i can't say for sure....but wouldn't the limit be the "size" of a variable
in lc?  ...and i think you can cram as much into your variable as you want
as long as you have the available ram....or you don't hit some OS
limit....like the one i love so much in windows.

i've done some pretty large select all queries..... and i've never had a
problem.

On Sun, Aug 6, 2017 at 2:59 PM, jbv via use-livecode <
[hidden email]> wrote:

> Hello
> Is there a size limit for the SQLQuery parameter when using
> revDataFromQuery ?
> I might end up with mySQL queries of at least 75 Kb...
> I know the best way to know is to try, but any experience would be
> apreciated...
>
> FYI some of there queries have been tested in PHPmyAdmin and run in 0.0054
> sec;
> my concern was rather the buffer size between LC engine and mySQL...
>
> Thanks in advance.
> jbv
>
>
> _______________________________________________
> use-livecode mailing list
> [hidden email]
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
_______________________________________________
use-livecode mailing list
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Maximum size of SQLQuery with revDataFromQuery ?

** Clarence P Martin ** via use-livecode
Query return data is more of a performance issue. The whole point to SQL is efficient data access, and a great deal of time is spend when teaching SQL on designing databases around that concept.

It's one thing if you have columns with large blobs, but if you are talking about returning large datasets with lots of records, it may be a design issue. You may want to consider creating some SQL functions that process the data on the server itself instead of having LC do the processing.

That being said, it is possible to "page" through the SQL data by using OFFSET and LIMIT. Just keep track of the offset, set the limit to something like 1000, and page your data in and store it as you see fit.

Bob S


> On Aug 7, 2017, at 10:48 , Tom Glod via use-livecode <[hidden email]> wrote:
>
> i can't say for sure....but wouldn't the limit be the "size" of a variable
> in lc?  ...and i think you can cram as much into your variable as you want
> as long as you have the available ram....or you don't hit some OS
> limit....like the one i love so much in windows.
>
> i've done some pretty large select all queries..... and i've never had a
> problem.
>
> On Sun, Aug 6, 2017 at 2:59 PM, jbv via use-livecode <
> [hidden email]> wrote:
>
>> Hello
>> Is there a size limit for the SQLQuery parameter when using
>> revDataFromQuery ?
>> I might end up with mySQL queries of at least 75 Kb...
>> I know the best way to know is to try, but any experience would be
>> apreciated...
>>
>> FYI some of there queries have been tested in PHPmyAdmin and run in 0.0054
>> sec;
>> my concern was rather the buffer size between LC engine and mySQL...
>>
>> Thanks in advance.
>> jbv


_______________________________________________
use-livecode mailing list
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Maximum size of SQLQuery with revDataFromQuery ?

** Clarence P Martin ** via use-livecode
Also using the query functions which allow iteration over the result set will minimise data transfer at any one point in time (assuming it's a decent client driver).

Warmest Regards,

Mark.

Sent from my iPhone

> On 7 Aug 2017, at 19:45, Bob Sneidar via use-livecode <[hidden email]> wrote:
>
> Query return data is more of a performance issue. The whole point to SQL is efficient data access, and a great deal of time is spend when teaching SQL on designing databases around that concept.
>
> It's one thing if you have columns with large blobs, but if you are talking about returning large datasets with lots of records, it may be a design issue. You may want to consider creating some SQL functions that process the data on the server itself instead of having LC do the processing.
>
> That being said, it is possible to "page" through the SQL data by using OFFSET and LIMIT. Just keep track of the offset, set the limit to something like 1000, and page your data in and store it as you see fit.
>
> Bob S
>
>
>> On Aug 7, 2017, at 10:48 , Tom Glod via use-livecode <[hidden email]> wrote:
>>
>> i can't say for sure....but wouldn't the limit be the "size" of a variable
>> in lc?  ...and i think you can cram as much into your variable as you want
>> as long as you have the available ram....or you don't hit some OS
>> limit....like the one i love so much in windows.
>>
>> i've done some pretty large select all queries..... and i've never had a
>> problem.
>>
>> On Sun, Aug 6, 2017 at 2:59 PM, jbv via use-livecode <
>> [hidden email]> wrote:
>>
>>> Hello
>>> Is there a size limit for the SQLQuery parameter when using
>>> revDataFromQuery ?
>>> I might end up with mySQL queries of at least 75 Kb...
>>> I know the best way to know is to try, but any experience would be
>>> apreciated...
>>>
>>> FYI some of there queries have been tested in PHPmyAdmin and run in 0.0054
>>> sec;
>>> my concern was rather the buffer size between LC engine and mySQL...
>>>
>>> Thanks in advance.
>>> jbv
>
>
> _______________________________________________
> use-livecode mailing list
> [hidden email]
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


_______________________________________________
use-livecode mailing list
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Loading...