How to limit returned rows?

[Ruslan Zasukhin]

On 8/1/13 8:16 PM, "Kevin" <kevo at gatorgraphics.com> wrote:

Hi Kevin,

So we talk about CSV export/import from  mySQL database,
Right?

Ok we will check.


=========
BTW, more good news from mySQL side.
We have solve one more  trouble with slow READ of mySQL schema objects,
Constraints in particular.

Next beta will have it ...


> On Aug 1, 2013, at 11:49 AM, Kevin <kevo at gatorgraphics.com> wrote:
>> 
>> Thanks Ruslan, the beta works much better. My next issue I just ran into is
>> that csv export seems to be really slow. I exported about 21,000 records,
>> only two fields of a table and it took about 5 minutes, maybe more, I wasn't
>> timing it. The export file only ended up being about 400KB. I can scroll
>> through the entire recordset in the built in viewer without any hitches at
>> all. This is from a postgres db BTW.
> 
> BTW, import is similarly slow. It took about 18 minutes to finish the import
> and it was 28,000 records, not 21,000 like I wrote originally.
> 
> Also, is it necessary to have the interface block while these are running.
> Seems like it would be nice to be able to interact with other tables or DBs
> while these longer running processes are going on.
> 
> - Kevin

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]