2011/10/23 Simon Slavin <slav...@bigfraud.org> > > My immediate question is why this is two rows in two separate tables rather > than one row in one table. After all, if tables always have the same rows > in, they might as well be the same row in one table.
I would love to have those rows into a single table, because those joins slow down the queries, but I have a mix of TEXT and INTEGER columns, and I had to move the TEXT columns to a different table (FTS virtual table), and I could not move the INTEGERs too, because FTS doesn't support them. > So we could ask you for your OS and disk format. But even then the answer > will be useful only for your exact current setup. The next time you get an > OS update things might change. Manufacturers tweak this stuff all the time. > It's Windows/NTFS, but I get the point. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
