How to limit returned rows?

[Sergey Pashkov]

Hello, Kevin,

I have a few questions on reproducing these issues.

What OS are you using for Valentina Studio, PostgreSQL server?
What version of PostgreSQL server?
Is the server really remote, somewhere on the internet?

I've checked on OS X, PostgreSQL 9.2 on localhost.
Import was slow. After a small fix it takes 23 seconds, for 2 fields, 28000 records.

Thank you.

--
Best regards,
Sergey Pashkov.


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