1. Santiago Garcia
  2. Valentina Studio
  3. 火, 5月 14 2019, 01:46 PM
  4.  メールで購読
I have two questions:

1. Why when i enter in the schema editor to the table list, the application freezes for a couple of seconds(~15s) and the it shows the tables list?
2. When i double click a table in the schema editor in order to open the data editor, it also freezes for a couple of seconds, how can i limit amount of rows so it's not that slow?

I'm using the version 9.1.4 in ubuntu 16.04
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hello Santiago,

Please add a few details.

What database is used?
How many tables are in the database?
Is it a connection to a remote host over the Internet?

You can open the Query Log from the main toolbar to see which query takes more time.

Data Editor loads 500 records - maybe some of the fields contain long texts? Or any table is opened slowly?
コメント
There are no comments made yet.
Santiago Garcia 承諾済みの回答
It's a remote mysql connection.
There are like 200 tables.
It doesn't matter if the table has 3 or 20 columns it takes a while to load all of them. But in mysql workbench it works faster than valentina studio.
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Could you please attach the query log, it contains timings for each query?
1. Query Log button on the main toolbar
2. Save To File button to save it to CSV
コメント
There are no comments made yet.
  • ページ :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.