I need advice in between MKT (metalized polyester film) and Ceramic capacitors . I am building a pulse discharging system which is required to discharge about 5KV through 10Ohm resistor in a time as fast as possible (say in pico seconds ~ us). Please can anyone advice me which type is best suited for such an application. The frequency of charging and discharging will be about 100Hz or so. I need this for experimentation with spark generation.
Picoseconds to microseconds is a range of a million to one, which doesn't really narrow things down much. "I need some money". "How much?" "Oh, somewhere between a hundred bucks and $100,000,000.00, as much as possible".
If you really want to make the discharge time as small as possible, I suggest two copper sheets separated by a dielectric.
For only 100pF, you could use a few square inches of 1/32" (0.8mm) double-sided PCB material, preferably wide and short with the connections across the entire width.
To get the fastest discharge you need to minimize the series inductance (and resistance) which means short wide current paths. Even a few inches of wire has significant inductance, and that will limit how fast the current can change. Even 100nH of series inductance (not much) will resonate with 100pF of capacitance at 50MHz, so you're not going to see really fast edges (even assuming whatever you're using as a switch could operate infinitely fast).
From the added information, perhaps consider something like the AVX HQCEMM101GAH6A, which has very low ESR (< 0.1 ohm) and a SRF of ~350MHz. Not cheap.
To answer this, you look in something called the "datasheet" for each of the candidate capacitors. In particular, parameters like the maximum ripple current, maximum pulse current, and equivalent series resistance (ESR) will be most relevant.
You may not find all these specs in all datasheets. Maximum pulse current is what you really want to know, but that is rarely specified. Capacitors with low ESR will have a ESR rating and usually a ripple current rating. The RMS of the ripple current times the ESR causes heating in the capacitor, which is usually what limits the ripple current spec. Calculate your RMS ripple current and eliminate any caps for which it is too high.
The instantaneous pulse current may be limited by other effects. Capacitors intended specifically for this kind of application will probably have a maximum pulse current spec, but otherwise probably not. If you can't find this spec, then identify a few capacitors that have a suitable ripple current spec and otherwise seem appropriate, and contact the manufacturer. Unless you find capacitors specifically intended for high pulse applications, this is a sufficiently off-mainstream application where you should have a conversation with some apps engineers from a few manufacturers.