Reply to thread

Message

<blockquote data-quote="d-fader" data-source="post: 189503" data-attributes="member: 25116">Hi guys!I've updated the Global Search plug-in to support the new database format. For some that is good news I guess <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" /> Expect an upload soon (since I first have to do some testing and for some reason my house doesn't understand how to clean itself) <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />.About the new database structure:&nbsp; Why didn't we use 'views'? In that way the database structure would've stayed the same, the retrieval of data would be as fast as the current structure and there would be no denormalization, something I am principally against. It is true that changing data (alter, insert, delete) takes a bit longer, but that's not really noticeable when you're adding data on the fly. I only can think of the upsides of this method, maybe it has downsides too, maybe you guys have thought about that <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />Please let me know! Thanks and expect the new version soon!Edit: By the way, you can't search on 'filename' anymore, since filename is removed from the database structure, in stead it will search the complete path + filename for your search phrase, something I'm not completely happy about, but it isn't a show stopper <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick Out Tongue&nbsp; &nbsp; :p" loading="lazy" data-shortname=":p" /></blockquote>

[QUOTE="d-fader, post: 189503, member: 25116"] Hi guys! I've updated the Global Search plug-in to support the new database format. For some that is good news I guess :) Expect an upload soon (since I first have to do some testing and for some reason my house doesn't understand how to clean itself) :). About the new database structure: Why didn't we use 'views'? In that way the database structure would've stayed the same, the retrieval of data would be as fast as the current structure and there would be no denormalization, something I am principally against. It is true that changing data (alter, insert, delete) takes a bit longer, but that's not really noticeable when you're adding data on the fly. I only can think of the upsides of this method, maybe it has downsides too, maybe you guys have thought about that :) Please let me know! Thanks and expect the new version soon! Edit: By the way, you can't search on 'filename' anymore, since filename is removed from the database structure, in stead it will search the complete path + filename for your search phrase, something I'm not completely happy about, but it isn't a show stopper :P [/QUOTE]

Verification