[Snowman12]

Hey,

Is it possible and are there any tutorials that can show me how to create a UCP and other server functions from a SQLite Database?

Thanks,

-Mike;

[Abbott]

It is possible but it is extremely slow once it has enough data in it, it will take years to load. I suggest sticking with MySQL, and I doubt there is a tutorial on it for this exact reason.

[Aldo.]

Quote:

Originally Posted by Abbott It is possible but it is extremely slow once it has enough data in it, it will take years to load. I suggest sticking with MySQL, and I doubt there is a tutorial on it for this exact reason.

Your wrong...

SQLite read operations can be multitasked, though writes can only be performed one at a time

[Scenario]

Just keep in mind that the SQLite database has to be local for both the UCP and SA-MP server in order for the speed not to be affected.

[Snowman12]

So if it was hosted there would be no issue?

[iLinx]

Quote:

Originally Posted by Abbott It is possible but it is extremely slow once it has enough data in it, it will take years to load. I suggest sticking with MySQL, and I doubt there is a tutorial on it for this exact reason.

Depends entirely on your I/O load, hard drive setup and I/O usage based on UCP traffic. It can be scaled using an appropriate budget easily, and in some cases SQLite is faster than MySQL. No need to discriminate

[Lorenc_]

There is nothing special about a UCP, I do not plan to make one since what's really the point? you just view your stats, see other players stats.. Etc. if you want something more interesting, go for IRC lol.

UCP makes roleplays unique afaik.