1. Santiago Garcia
  2. Valentina Studio
  3. Вторник, Май 14 2019, 01:46 PM
  4.  Подписаться через email
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 Ответ принят
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.
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 Ответ принят
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.
  • Страница :
  • 1


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

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories