Comment by tester756

4 years ago

>Maybe in gigantic systems with more tables than makes sense. Realistically, all of the columns available in a database can be fit in memory with ease.

Every table has more than one column

So there's always more columns to remember than tables and generally tables are pretty easy like user invoices blabla

I worked with systems that had like 500 tables and some of them with 20-50 columns

you really want good intellisense in such a environment

3 comments

tester756

Reply
taeric  4 years ago

500 times 50 is still not a big number. And you could do decent statistical suggestions on the current columns in.

Good intelligent suggestions is, of course, helpful. And I agree that suggesting one of 500 is easier than the other. That said, neither is hard for a computer. And even asking friends what table I want will often be done with starting with the actual columns I want.

  • tester756  4 years ago

    On the other hand I don't see why it couldnt work both ways

    if you start query with

    SELECT MiddleName then you could receive auto complete thats adds "FROM Users" and moves your cusor after MiddleName.

    if you start query with

    FROM Users SELECT _ and know intellisense drops list of columns