How to limit returned rows?

[Kevin]

Postgres. 

On Aug 2, 2013, at 3:48 AM, Ruslan Zasukhin <ruslan_zasukhin at valentina-db.com> wrote:

> 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]
> 
> 
> _______________________________________________
> Valentina-studio mailing list
> Valentina-studio at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-studio
>