Lag when pressing dot character in sql file about vim-dadbod-completion HOT 4 CLOSED

Hi @RRikor,

how big is your database? 10212 is the number of results that are being mapped, that's why you see 10212 entries in there.
I agree it's big and it should be optimized.

Can you tell me if you just type the . or you type something before it?

For example, do you get lag when you type something like this:

select * from posts.

Or you just type the dot and get the lag?

.

from vim-dadbod-completion.

Hi @kristijanhusak,

Thank you for the quick reply! And thanks for the tip! The lag was happening when I pressed the dot and when I pressed the schemaname+dot. In both occasions.

I am writing tables for a new schema in a PostgreSQL database. The schema is currently empty. So I guess if
the plugin can't find the schema, or when the schema is empty, it loads all results from pg_tables.tablename + some other pg_ tables into the list?

I created a dummy table in the schema and now it only displays that dummy table when using schemaname+dot. So the lag is gone :-)

Though it would be nice if it would limit the results in the list somehow. Apparently the maximum number of columns in PostgreSQL is 1600. https://www.postgresql.org/docs/current/limits.html

Thanks for the help!

Edit: It also still happens when giving the table an alias, for example:
select t1.*, t2.* from bla.table1 as t1 inner join bla.tabl2 as t2 on t1. <---- lag occuring
So that limit would be a nice addition.

from vim-dadbod-completion.

@RRikor I introduced a limitation for each source returned to 50. If you pull latest master, it should be working better for you.
If you want to configure limits follow the docs

Let me know if it's better.

from vim-dadbod-completion.

Perfect! Thanks very much for the quick fix!

from vim-dadbod-completion.