source: trunk/scripts/ia_job_reindex @ 1184

Revision 965, 517 bytes checked in by bogdan2412, 3 years ago (diff)

Make it possible for disk cache to handle more complex paths for files (for example to put all files beginning with ab in cache/a/ab/)
Since I don't know how we can benchmark this properly the default behaiviour is still the same as before (all cache files are put in IA_ROOT_DIR/cache/)

Also, I added a few fixes from live.
  • Property svn:executable set to *
Line 
1#! /usr/bin/env php
2<?php
3require_once(dirname($argv[0]) . "/utilities.php");
4
5db_connect();
6$query = "ALTER TABLE `ia_job`
7    DROP INDEX `by_round`,
8    ADD INDEX by_round USING BTREE(`round_id`, `id`),
9    DROP INDEX `by_task`,
10    ADD INDEX by_task USING BTREE(`task_id`, `id`),
11    DROP INDEX `by_round_task`,
12    ADD INDEX by_round_task USING BTREE(`round_id`, `task_id`, `id`),
13    DROP INDEX `by_user`,
14    ADD INDEX by_user USING BTREE(`user_id`, `id`),
15    DROP INDEX `submit_time`";
16
17db_query($query);
18
19?>
Note: See TracBrowser for help on using the repository browser.