Judger | Judge system for Sicily Online Judge | Learning library

You can use pluck function to get all ids of candidates and use whereIn.

So, there is no need to use loop, use group by and simple raw query.

Just change your function like,

The C standard specifies that

A preprocessing directive of the form

Both code samples have algorithmic complexity of O(n), but you shouldn't be fooled by big O as it only shows trend. Execution time for an O(n) algorithm can be expressed as C * n where C is constant which depends on many factors.

For .count() code, you'll need to do 4 loops in string_count() C function, but C functions are fast. It also uses some advanced algorithms inside like fastsearch. Only string search is performed here, minimum interpreter overheads.

In the pure Python code you need only single loop, but each iteration will require to execute much more lower-level code because Python is the interpreted language*. For example, you're creating new unicode or string object for each iteration of the loop, and creating objects is a very expensive operation. Since integer objects are immutable, you'll need to re-create them for each counter.

^{* Assuming you're using CPython interpreter, which is pretty much default}

I have trouble supplying each cmdline options everywhere.

Why? Are you using some build automation tool like GNU make? I believe you should use it, then it is just a matter to add a few appropriate lines in your Makefile (probably something like adding a line such as CXXFLAGS += -DHAVE_CONFIG_H -O2 -std=c++11)

Are all cmdline arguments replaceable by # lines? If not, what args are replaceable?

You mean replaceable by preprocessor directives. Read documentation of cpp

Actually, most compiler options are not replaceable by preprocessor directives; notably

• -std=

• -L and -l and any other options for the linker

• -I and similar options for include directories

However, -O2 and some other optimization flags are settable by function attributes e.g. __attribute__((optimize("O2")) (see this) and by function specific option pragmas e.g. #pragma GCC optimize "-O2". Notice that this is specific to GCC.

I recommend spending a few hours reading the documentation of GCC.

You might also perhaps change your spec file, but I don't recommend doing that.