Level 73
Very simple, don't use uuid or similar as the primary key, you should use an integer as your primary key, because indexing doesn't really work well on random strings.
Dec 17, 2023
7
Level 28
Eloquent Performance on Jetstream
Laravel Jetstream browser session already gives me low performance. How can I fix that?
Level 28
@Tray2 I did not do anything. It's just a default laravel jetstream browser session.
Level 28
@Tray2 default jetstream session database.
public function up(): void
{
Schema::create('sessions', function (Blueprint $table) {
$table->string('id')->primary();
$table->foreignId('user_id')->nullable()->index();
$table->string('ip_address', 45)->nullable();
$table->text('user_agent')->nullable();
$table->longText('payload');
$table->integer('last_activity')->index();
});
}
Level 122
local or remote database?
Level 28
@Snapey local database.
Level 122
@shaungbhone 15ms does seem slow locally but its more likely to be your Db than laravel imo
1 like
Level 28
@Snapey For me "yes". By default 20MB. xd
Please or to participate in this conversation.