# interview

**Repository Path**: fanjiabin/interview

## Basic Information

- **Project Name**: interview
- **Description**: A project for interview.
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2022-07-12
- **Last Updated**: 2022-07-14

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# Interview Project

this is a project for interview.

## API Document

[https://gitee.com/fanjiabin/interview/wikis/api/find%20users%20api?sort_id=5818478](https://gitee.com/fanjiabin/interview/wikis/api/find%20users%20api?sort_id=5818478)

## Development Environment

```
Symfony framework (version 6.1)
PHP 8.1
Mysql 5.7
Composer version 2.3.5 [https://getcomposer.org/download]
```

if your development environment is ready ,

## run the project

then :

```
step 1: install Symfony CLI [https://symfony.com/download]
step 2: git clone or download the code
step 3: composer install --no-dev
step 4: symfony server:start
```

## unit test

```
use phpunit

php bin/phpunit tests/UserTest.php
```

## Other Performance optimization
```
In order to improve performance, I made parameter restrictions and paging queries, I think the following ways are also possible:
1. cache 
2. optimize database indexes , like these columns `is_active`, `is_member`, `last_login_at`, `user_type`
3. reduce the data fields returned by the interface

```