Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote -1 down vote favorite

Using PHP with mysqli, when I run a simple insert on my laptop I get 21 inserts per sec.

I'm using Windows (A WAMP architecture) and have 4GB RAM, a 500 GB SATA (7200 RPM) disk.

Is my performance too slow? Should I expect faster performance on a "real server" instead of my laptop?

share|improve this question
What are you using to test? – Michael Capobianco Feb 13 at 21:14
1  
This is really too vague. I'm about 24 hours from closing the question as "Not a real question". We need more details, such as table schema, insert examples, and the like. If need be, you can recreate on SqlFiddle. – jcolebrand♦ Feb 13 at 21:27

closed as not a real question by Mark Storey-Smith, Paul White, dezso, Jon Seigel, Leigh Riffel Feb 18 at 13:26

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, see the FAQ.

1 Answer

up vote -1 down vote

It depends on how big your insert queries are. It does seem kind of slow. If the real server was just running MySQL then it will more than likely have faster QPS (Queries Per Second).

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.