1. Santiago Garcia
  2. Valentina Studio
  3. Tuesday, May 14 2019, 01:46 PM
  4.  Subscribe via 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
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
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?
Comment
There are no comments made yet.
  1. one week ago
  2. Valentina Studio
  3. # 1
Santiago Garcia Accepted Answer
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.
Comment
There are no comments made yet.
  1. one week ago
  2. Valentina Studio
  3. # 2
Sergey Pashkov Accepted Answer
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
Comment
There are no comments made yet.
  1. one week ago
  2. Valentina Studio
  3. # 3
  • Page :
  • 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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories