These are chat archives for eventum/eventum

17th
Nov 2015
Bryan Alsdorf
@balsdorf
Nov 17 2015 16:22
@glensc So I asked our support / consultants about it column order. This is what I got back:
"it doesn't, as innodb doesn't do partial row reads (except blobs which can be stored entirely off page) so when you read col1 or col3, at the end you are reading row Y which contains col1,col2,col3,col4"
Elan Ruusamäe
@glensc
Nov 17 2015 16:26
I use myisam, and it is still eventum default afaik. Can you clarify that part too?
Sometimes even mysql 5.0
Bryan Alsdorf
@balsdorf
Nov 17 2015 16:27
Woah it is the default...
Elan Ruusamäe
@glensc
Nov 17 2015 16:28
I mean not the default part, but behaviour in that engine :)
Bryan Alsdorf
@balsdorf
Nov 17 2015 16:35
hah yes I know. I asked for feedback on that. One guy said he believes it is the same but he mainly works with InnoDB. I'm waiting for one of the other guys to chime in
Do you still use fulltext search? Or is there some other reason you are on MyISAM still?
Elan Ruusamäe
@glensc
Nov 17 2015 16:50
I use sphinx for that. And i like myisam for its simplicity setting up replicas and doing backups on binary files
Innodb backup, cant be done with mysqlhotcopy and havent gotten to use better tools
There is some percona tool, which i even have compiled, but still not used
For myisam few dbs we have, doing mysqldump style backup as those dbs are small
Bryan Alsdorf
@balsdorf
Nov 17 2015 16:58
The comment from one of our senior support engineers is that on MyISAM it can make a small different with varchars / blob at the end of the table def. Int type order won't matter, put your most accessed columns first.
Elan Ruusamäe
@glensc
Nov 17 2015 17:46
Ok. So i guessed
Bryan Alsdorf
@balsdorf
Nov 17 2015 18:52
@glensc Do I need to manually setup debugbar? I assumed composer would install it but it hasn't been installed and is causing JS errors
Elan Ruusamäe
@glensc
Nov 17 2015 18:55
Need to make symlink in htdocs
i guess, can add the link in git, sec, i'll commit it
done
Elan Ruusamäe
@glensc
Nov 17 2015 19:36
but there's some error that debugbar needs to be initialized once
but pages that create second Template instance, do it twice. and thus fatal errors
i think need to add new class
which brings up issue that we should structure our code better
move code to src/ and use hierarchy and probably namespaces
and i have some long standing dream to add "controllers" logic
i.e each htdocs/*.php uses some controller style logic
and the main classes stay clean and deal with business logic
i have some dev somewhere where i created the BaseController
i think i showed you some code, no?
Elan Ruusamäe
@glensc
Nov 17 2015 19:41
so i currently will add Eventum\DebugBar class, what you think, commit it to src/ directory then?
Elan Ruusamäe
@glensc
Nov 17 2015 20:19
and how would you see the layout there?
just put new classes to root dir (src/DebugBar.php), and figure out later how to subdir them?
or src/Eventum/DebugBar.php ?