[Gambas-user] file size limit on sql file in gambas????

Fabien Bodard gambas.fr at ...626...
Wed Oct 19 17:14:10 CEST 2011


what can be stored in 2GB ..; that's a big database !! :-)... i think
you must use dbms server such as mysql, or postgresql

2011/10/19 Caveat <Gambas at ...1950...>:
> ISTR at one time Benoit saying that the drivers for some of the dbs
> weren't that smart and may read the whole table into memory.
>
> How much RAM do you have?  Can you see how much you have free as the
> program runs?
>
> 2Gb or more also sounds like it may be hitting some kind of limit
> (certainly historically 2Gb was pretty much a hard and fast limit for
> 32-bit Linux systems).
>
> Perhaps you may have to consider splitting the database or moving to
> another DBMS?
>
> Regards,
> Caveat
>
> On Tue, 2011-10-18 at 11:16 -0700, Ivan Williams wrote:
>> Greetings once more
>>
>> I have been doing some experimenting with the unable to locate database error in gambas.  I am able to open smaller files but when I attempt to open the most current current version of the file (2.4 GB) in size the program blows up.   Does anyone know if gambas has any file size limits and if so, how can they be bypassed.
>>
>>
>>
>> Ivan    \~/
>>
>>
>> I never saw a wild thing sorry for itself.
>> A small bird will drop frozen dead from a bough
>> Without ever having felt sorry for itself.
>> -- D.H. Lawrence
>>
>>
>> http://www.usconstitution.net/const.html
>>
>> Linux - Live Free or Die.
>> ------------------------------------------------------------------------------
>> All the data continuously generated in your IT infrastructure contains a
>> definitive record of customers, application performance, security
>> threats, fraudulent activity and more. Splunk takes this data and makes
>> sense of it. Business sense. IT sense. Common sense.
>> http://p.sf.net/sfu/splunk-d2d-oct
>> _______________________________________________
>> Gambas-user mailing list
>> Gambas-user at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/gambas-user
>
>
>
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure contains a
> definitive record of customers, application performance, security
> threats, fraudulent activity and more. Splunk takes this data and makes
> sense of it. Business sense. IT sense. Common sense.
> http://p.sf.net/sfu/splunk-d2d-oct
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>



-- 
Fabien Bodard




More information about the User mailing list