Creating a table on Install
#3
Any attributes your are giving to a column must be after the column name and column type. Looking over your proposed table structure though it is not going to be optimal by any means, especially if you need to do a search on it. The less columns that use TEXT or VARCHAR the better you will be for performance. I don't see why you don't just drop all the extra turn columns and put an Index on the column thread. You will have much better performance in this way. You can still sort them by id to display the order of turns.
Reply


Messages In This Thread
Creating a table on Install - by Algraud - 2016-11-18, 08:59 PM
RE: Creating a table on Install - by VirtualFrost - 2016-11-19, 11:04 AM
RE: Creating a table on Install - by dragonexpert - 2016-11-19, 02:23 PM
RE: Creating a table on Install - by Algraud - 2016-11-21, 05:27 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)