How to limit returned rows?

[Kevin]

This was from OS X over the internet to a remote Postgres server. I believe the server was version 9.1.9 IIRC. After doing another test, it looks like it pushes a max of about 7-10KB/s of data while doing the export and import. I can run a test again when I have time and give more specific info it you let me know what you need.

- Kevin

On Aug 3, 2013, at 10:27 AM, Sergey Pashkov <sergey_pashkov at valentina-db.com> wrote:

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